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.
Hi,
Has this ever been implemented in power bi? Seems like years since it was suggested but despite recent changes to quick measures the running total quick measure is still fairly useless.
I have a table with (CUMULATIVE being my requirement). There is an entry for each month, and 3 cycles per year but hopefully you get the idea.
YEAR_CYCLE (text) | MONTH | TOTAL | CUMULATIVE |
2023 1 | 01/01/2023 | 5 | 5 |
2023 1 | 01/02/2023 | 10 | 15 |
2023 2 | 01/05/2023 | 7 | 7 |
2023 2 | 01/06/2023 | 6 | 13 |
As I do have a sequential date field, I'm hoping I don't need an index but can't quite get it right. Can anyone assist with the DAX for the cumulative total / running total by cycle?
Solved! Go to Solution.
Yes, that's what the formula does. Two separate cumulations.
Sorry, my mistake. The formula requires "Cycle" to be a field in the output and I'd removed it.
Works great, thanks
Hi,
Unless I'm missing something, that only gives me a running total. What I need is a running total that resets each time the Cycle changes.
Yes, that's what the formula does. Two separate cumulations.
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 |
---|---|
101 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |