Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative Total Measure

Hi, 

 

I need a measure to calculate the Cumulative Total Revenue from the average revenue from this data set:

 

So the answer that I want should look similar to this chart below. But instead of just showing the sum of revenue by rank, I want to show the cumulative revenue by rank.

So this chart is to see for each cohort start on a specific month, how long they study with the center and how much revenue they generate for the center.

 

Thanks a lot for your help!!! 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , need some test data.

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    You can get Cumulative  with date table like example

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=maxx(date,date[date])))
    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(Sales[Sales Date])))
    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,max(dateadd(date[date]),-1,year))))

     

    For Cohort refer :

    https://www.youtube.com/watch?v=Q1vPWmfI25o

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.