DAX cumulative sum measure

[sm1driver]

Hi,

I need to produce a measure that's cumalative as per the weeks.
The summation needs to reset when the new year hits.

Any help would be appreciated.

[govind_021]

Hi , @sm1driver 
You can also use Visual Level Calculation Running Sum formula
Go To Three dots in the visual and Select "new calculations" and use below formula

RUNNINGSUM([Amount], HIGHESTPARENT)

For more details check out this : https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview

[sm1driver]

Thanks so much! Lifesaver!

[anmolmalviya05 · Accepted solution]

Hi , I hope you are doing good!

Please try the below solution:

Cumulative Amount =
VAR CurrentYear = MAX('Table'[Year])
VAR CurrentWeek = MAX('Table'[Week])
RETURN
CALCULATE(
SUM('Table'[Amount]),
FILTER(
ALL('Table'),
'Table'[Year] = CurrentYear &&
'Table'[Week] <= CurrentWeek
)
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

@sm1driver