Forum Discussion

Vinod_P's avatar
Vinod_P
Icon for Helper I rankHelper I
3 years ago

Arears in single column

Created this report in power BI , Looking for an arears only on column instead of spreading across all the dates.  Arears = cumulative supply - cumulative demand with date filter as max of previous ...
General Comment
Interesting Links
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Vinod_P , Try like

 

CALCULATE(SUM(Table[Supply]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Demand),filter(date,date[date] <=eomonth(maxx(date,date[date]),-1) ))

 

 

 

Something similar to below one, with use eomonth to move to last month

Power BI Inventory On Hand
Power BI Inventory On Hand: https://youtu.be/nKbJ9Cpb-Aw