closing stock calculation

[vigneshkumarkr]

i need to calculate the closing stock by adding the previous month clsoing stock, current month receipt, production and subracting the demand.

[PaulDBrown]

Please share actual data (not an image).. Thanks!

[vigneshkumarkr]

https://1drv.ms/x/s!AsL9U5y3wlvev08WgqIqlp0oKuNi?e=CuXo02 

[PaulDBrown · Accepted solution]

See if this works for you

I've attached the sample PBIX file

[Ashish_Mathur]

Closing stock is already there in the data sheet.  What more do you want.  Elaborate.

[vigneshkumarkr]

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

[Ashish_Mathur]

I believe Paul has already answered your question.