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.

[TABLE="class: grid, width: 489, align: center"]
<tbody>[TR]
[TD="colspan: 7, align: center"]Location Wise Stock[/TD]
[/TR]
[TR]
[TD]Month[/TD]
[TD]Opening[/TD]
[TD]ABS[/TD]
[TD]GDC[/TD]
[TD]TCP[/TD]
[TD]ADG[/TD]
[TD]Closing Blance[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]10,000[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]1,000[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]12,000[/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD][/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]900[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]1,000[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD][/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]1,287[/TD]
[TD="align: right"]455[/TD]
[TD="align: right"]450[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD][/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]999[/TD]
[TD="align: right"]343[/TD]
[TD="align: right"]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[TD][/TD]
[TD="align: right"]450[/TD]
[TD="align: right"]1,500[/TD]
[TD="align: right"]786[/TD]
[TD="align: right"]200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]10,000[/TD]
[TD="align: right"]2,750[/TD]
[TD="align: right"]6,686[/TD]
[TD="align: right"]2,784[/TD]
[TD="align: right"]1,500[/TD]
[TD="align: right"]12,000[/TD]
[/TR]
</tbody>[/TABLE]

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.