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

 

Below sample snap FYR

 

 

 

General Comment
Interesting Links
Need Help
Tips and Tricks

1 Reply

  • 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