Cohort base cumulative sum

[Anonymous]

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

[Anonymous]

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

Hi @Anonymous ,

Sorry I cannot get you based on your data. Could you please share more details about that?

[Anonymous · Accepted solution]

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

[amitchandak]

Can you share some sample data.