Cumulative total by category

[wynhodgkiss]

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?

[wynhodgkiss]

Sorry, my mistake. The formula requires "Cycle" to be a field in the output and I'd removed it.

Works great, thanks

[lbendlin]

[Anonymous]

How to get the Total right for Cumulative now?

[lbendlin]

@Anonymous please open a new thread.

[wynhodgkiss]

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.

[lbendlin · Accepted solution]

Yes, that's what the formula does. Two separate cumulations.