Forum Discussion
AsadAliKhan
5 years agoFrequent Visitor
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...
Greg_Deckler
5 years agoCommunity Champion
AsadAliKhan If that is a representation of your source data then unpivot your month columns in Power Query.
AsadAliKhan
5 years agoFrequent Visitor
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