Calculation of Opening and Closing Balance (DAX)

[tusharmehta]

Hello Everyone,

How are you doing ?

I have came across to some type of situation where I need to transfer calculated closing balance figures next month opening balance figure.

I have tried using calculation and other dax formula but I am not able to produce the result which I am looking for.

It seems I am missing something and it could be simple but I am not able to to figure out.

So will you please guide me the same.

Location Wise Stock
Month	Opening	ABS	GDC	TCP	ADG	Closing Blance
Jan	10,000	500	1,000	300	200	12,000
Feb		300	900	400	200
Mar		400	1,000	500	150
Apr		500	1,287	455	450
May		600	999	343	300
Jun		450	1,500	786	200
Jul
Aug
Sep
Oct
Nov
Dec
	10,000	2,750	6,686	2,784	1,500	12,000

<tbody>
</tbody>

As mentioned on above mentioned sheet I need to learn how to transfer each month closing to next month and in next month it will get calculated as opening.

Thanks in Advance.

 

[TimRodman]

The phrase "I would probably start here" at the end of my previous post is a link.

 

[tusharmehta]

Thanks I found the url and I will start looking into it.

Appreciate for your responses and guidance.

 

[Ramzan11b]

Thanks I found the url and I will start looking into it.

Appreciate for your responses and guidance.

Hy tusharmehta! Have you got the solution?
Please share the solution with me. I also need to calculate opening closing balance for power pivot but i am facing problems.