Forum Discussion

Dave_Delfino's avatar
Dave_Delfino
Frequent Visitor
5 years ago
Solved

Cumulative Column Values where every column represents a month and every line a measure

Hello PBI-firends,   I have a prefilled datatable for futue project management purposses. Every line represents a measure that should save money. Every column (at least those of interest) represe...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Dave_Delfino , the screenshot is not very clear.

    You need to unpivot the data.

    Then you need take out month year from it

    create date from month year and then create cumulative like example

     

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))


    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Dave_Delfino , the screenshot is not very clear.

You need to unpivot the data.

Then you need take out month year from it

create date from month year and then create cumulative like example

 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))


Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))