Closing Blance calculation

[AsadAliKhan]

Hi All,
I am new to DAX and trying to create a pivot report through Power BI, where month end closing balance is calculated by subtracting Fcast and adding Transit and On order quantity of respective month and previous month closing stock. see the sample below.

will appreciate your help

Regards,
Asad

[v-luwang-msft]

Hi 

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Ashish_Mathur]

Hi,

In an MS Excel file, share your data and in another tab, show your expected result with your Excel formulas.

[AsadAliKhan]

Thank you, Ashish

Please see the link below

https://1drv.ms/x/s!ApmDRAP7RNB2iHWN1hOflBBSFY6Y?e=g4GJx3

Regards

Asad

[AsadAliKhan]

Dear Ashish

Hope you will be fine!

Do you have any luck?

Regards,

Asad

[Ashish_Mathur]

Hi,

Sorry but i have not had the chance to look at this.  May be someone else can help you.

[Ashish_Mathur]

Hi,

I do not see any formulas in row 13 of the Result worksheet.  Also, why are so many sheets required in the workbook?

[AsadAliKhan]

Dear Ashih,

I appreciate your interest, yes, there is no formula in row 13 for past month (Jul till Aug) as they are actual values while there is a formula from Sep onward (Column H) till last month.

we have seperate sheets to inorporate everyone needs.

Once again Thank you

Asad

[Greg_Deckler]

@AsadAliKhan If that is a representation of your source data then unpivot your month columns in Power Query.

[AsadAliKhan]

Hi Greg,

Thank you for interest, No there are different tables for each measure. If you sahare your email I can forward you.

Thank you Once again.

Asad