Closing Blance calculation

Question

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 helpRegards,Asad

greg_deckler · Answer

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

asadalikhan · Answer

Hi Greg,&nbsp;Thank you for interest, No there are different tables for each measure. If you sahare your email I can forward you.&nbsp;Thank you Once again.Asad

ashish_mathur · Answer

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

asadalikhan · Answer

Thank you, Ashish&nbsp;Please see the link belowhttps://1drv.ms/x/s!ApmDRAP7RNB2iHWN1hOflBBSFY6Y?e=g4GJx3&nbsp;RegardsAsad

ashish_mathur · Answer

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

Forum Discussion

Closing Blance calculation

9 Replies

Related content

Closing value

Calculating closing balance

Stock opening closing calculation

Calculate Ageing of closed incidents based on Incident closed date

Removing blancs from ragged hierarchy in Power BI Matrix visual