Arears in single column

[Vinod_P]

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 month. 

Below sample snap FYR

[amitchandak]

@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