Calculating Closing Stock balance from the previous month's closing Stock

[rocky09]

Hello, I am stuck with this dataset. My task is to calculate the Closing Balance for each and every month. But not sure, how do I achieve this. Can anyone please help?

To calculate the Closing Balance, the Logic  is :
Prev.Month Closing Stock + Cur.Month Production + Cur.Month Receipts - Cur.Month Demand

The expected answer should be something like this:

[rocky09]

@amitchandak @Ashish_Mathur @SpartaBI 

Can anyon help with this problem?

[Ashish_Mathur]

Hi,

Share your source data (not the format in which you want to see the report) in a format that can be pasted in an MS Excel file.

[rocky09]

Hi @Ashish_Mathur 
Here is the data as requested.  I have received the data in the same format as below.

Product	Category	Mar-22	Apr-22	May-22	Jun-22	Jul-22
Cable	Demand		4092	6050	3802	5784
Cable	Receipts		7030	4500	4615	5543
Cable	Production		0	0	0	2515
Cable	Closing Stock	4601
Pipe	Demand		7584	5894	4875	2254
Pipe	Receipts		2245	3332	2245	5578
Pipe	Production		125	0	664	3654
Pipe	Closing Stock	7825

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[rocky09]

wow..

Thank you so much. This is what I am looking for.

[Ashish_Mathur]

You are welcome.

[Shishir22]

Hello @rocky09,

Request you to please share data in tabular format.

[rocky09]

Here it is:

Product	Category	MAR 2022	APR 2022	MAY 2022	JUN 2022
Cable	Demand		4092.834	6050.999	3802.334
Cable	Receipts		7030	4500	4615.38
Cable	Production		0	0	0
Cable	Closing Stock	4601