Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |