I'm trying to create a calculated column that calculates the cumulative sum. I created one in a DAX measure and its working fine:
Go to Solution.
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
View solution in original post
Thanks for your response.
I have tried your solution but it still doesn't give the correct output as you can see below:
@Aymane , a new column
CumulativeCount =CALCULATE(SUM(Fact_CRM_CT[Count]),FILTER((Fact_CRM_CT),Fact_CRM_CT[DateKey] <= earlier(Fact_CRM_CT[DateKey]) ))
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.