Create a calculated column for cumulative sum by Date

[Aymane]

I'm trying to create a calculated column that calculates the cumulative sum. I created one in a DAX measure and its working fine:

CumulativeCount =

CALCULATE(

     SUM(Fact_CRM_CT[Count]),

    FILTER(ALLSELECTED(Fact_CRM_CT),Fact_CRM_CT[DateKey] <= MAX(Fact_CRM_CT[DateKey]) ))

I want to recreate the same in a calculated column but it is not working as expected.

[Aymane]

Hi @amitchandak,

Thanks for your response.

I have tried your solution but it still doesn't give the correct output as you can see below:

[v-easonf-msft · Accepted solution]

Hi, @Aymane 

You are using a calculated column instead of measure column to display the result, so the final result is aggregated without recomputing.

You just need to change the summarize type of  calculated column 'Cumulative Count' from 'Sum' to 'Maximum'/'Minimum'/'Average'.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Aymane , a new column

CumulativeCount =
CALCULATE(
SUM(Fact_CRM_CT[Count]),
FILTER((Fact_CRM_CT),Fact_CRM_CT[DateKey] <= earlier(Fact_CRM_CT[DateKey]) ))