Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to create a calculated column that calculates the cumulative sum. I created one in a DAX measure and its working fine:
Solved! Go to 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
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:
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
@Aymane , a new column
CumulativeCount =
CALCULATE(
SUM(Fact_CRM_CT[Count]),
FILTER((Fact_CRM_CT),Fact_CRM_CT[DateKey] <= earlier(Fact_CRM_CT[DateKey]) ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |