Forum Discussion
Closing Blance calculation
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 respectiv...
Ashish_Mathur
Super User
Super UserHi,
I do not see any formulas in row 13 of the Result worksheet. Also, why are so many sheets required in the workbook?
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