Forum Discussion
Advocate IICumulative total by category
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?
Yes, that's what the formula does. Two separate cumulations.
6 Replies
- lbendlin
Super User
wynhodgkissHi,
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.
- lbendlin
Yes, that's what the formula does. Two separate cumulations.
- lbendlin
Anonymous please open a new thread.
- wynhodgkiss
Sorry, my mistake. The formula requires "Cycle" to be a field in the output and I'd removed it.
Works great, thanks
