Forum Discussion
Solved
closing stock calculation
i need to calculate the closing stock by adding the previous month clsoing stock, current month receipt, production and subracting the demand.
See if this works for you
I've attached the sample PBIX file
PaulDBrown
Community Champion
Community ChampionPlease share actual data (not an image).. Thanks!
- Ashish_Mathur
Super User
Closing stock is already there in the data sheet. What more do you want. Elaborate.
I have calculated the closing stock using you method from your one of the previous post, but while applying the same in the matrix table closing stock is wrong, it didnt add the previous month closing stock...
pls check the excel data
https://1drv.ms/x/s!AsL9U5y3wlvev08WgqIqlp0oKuNi?e=K51gSx
pbix file: https://1drv.ms/u/s!AsL9U5y3wlvev05GIyc65oEnvU6z?e=cOBnUB
- PaulDBrown
See if this works for you
I've attached the sample PBIX file
