tusharmehta
New Member
- Joined
- May 12, 2014
- Messages
- 34
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.
<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.
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.