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])))

Dave_Delfino's avatar
Dave_Delfino
Frequent Visitor
5 years ago

Hello Amit!

 

Thank you for your fast reply. I will go ahead and google the phrases you used to explain your solution.

Sorry for the not self-explanatory screenshots. i will come back to you as soon as i have solved my issue or are stuck again.

 

Greeting,

David