Forum Discussion
Cohort base cumulative sum
Hi all,
I was wondering if someone can could help me.
I have data like below, what i want to have cumulative sum for each day (column) and by cohort day ( row) basically in excel this could be done :
for example the 25 march the 1 day will be 57158.
What is the best measure to get this please?
regards
Darren
my solution was
Cumulative Cohort Revenue = ( CALCULATE (SUM('Cohort rev_2'[revenue] ),FILTER(ALLEXCEPT('Cohort rev_2','Cohort Rev_2'[cohort_day],'Cohort rev_2'[campaign_type],'Cohort rev_2'[app],'Cohort rev_2'[dim_country],'Cohort rev_2'[install_type]),'Cohort Rev_2'[Install days_diff]<=MAX('Cohort rev_2'[Install days_diff]))))
4 Replies
- amitchandak
Super User
Can you share some sample data.
Hi,
Please see below, just some sample
app cohort_day days_diff country_id rev this 11/03/2020 7 0 29.96 this 11/03/2020 9 0 56.97 this
11/03/2020 5 0 36.97 this 11/03/2020 2 0 17.99 this 11/03/2020 8 0 2.99 this 11/03/2020 3 0 17.99 this 11/03/2020 1 0 0.99 this 11/03/2020 0 0 3.99 this 11/03/2020 0 7 1.98 this 14/03/2020 0 79 0.99 this 11/03/2020 1 20 68.94 this 11/03/2020 0 20 190.82 this 11/03/2020 0 38 0.99 this 11/03/2020 13 38 65.96 this 11/03/2020 10 16 2.99 this 11/03/2020 6 16 4.98 this 11/03/2020 3 16 10.98 this 11/03/2020 7 16 3.99 this 11/03/2020 8 16 3.98 this 11/03/2020 0 16 1.99 this 11/03/2020 5 16 7.97 this 11/03/2020 12 16 17.99 this 11/03/2020 2 16 0.99 this 11/03/2020 11 16 8.99 this 11/03/2020 0 33 0.99 
v-frfei-msftCommunity Support
Hi Anonymous ,
Sorry I cannot get you based on your data. Could you please share more details about that?
my solution was
Cumulative Cohort Revenue = ( CALCULATE (SUM('Cohort rev_2'[revenue] ),FILTER(ALLEXCEPT('Cohort rev_2','Cohort Rev_2'[cohort_day],'Cohort rev_2'[campaign_type],'Cohort rev_2'[app],'Cohort rev_2'[dim_country],'Cohort rev_2'[install_type]),'Cohort Rev_2'[Install days_diff]<=MAX('Cohort rev_2'[Install days_diff]))))
