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 again,

 

i have managed to un-pivot the needed data (Thank you for that hint!). But for now i have problem with cumulating the data in a measure.

 

Kosolidierung = Cosolidation (Name of table)
Einsparung = Savings (what i want to cumulate)
Datum = Date (well.., the date)

 

do you have another hint for me on that regard?

best regards,

David

Dave_Delfino's avatar
Dave_Delfino
Frequent Visitor
5 years ago

Please ignore my message. The answer you gave were completly sufficient to solve the problem.

My second problem (cumulation) has been resolved by formating the column to from text to decimal.

 

Again, thank you Amit.