Cumulative values

DAX DAX Calculations
3

@pedroccamara,

I recently worked on a similar solution for resetting cumulative totals on a different field. Here’s the general structure from that thread:

image

(1) is the cumulative total pattern
(2) resets it for each value of the relevant field using ALLEXCEPT()

Hopefully, this gets you what you need. If not, please provide your PBIX and I can provide a more specific solution.

Thanks.

  • Brian

P.S. Here’s another thread I found, with a biennial reset of cumulative total. Pattern will be the same, just with FY for your case.