Running total in calculated column

[Irwin]

Hi,

I want to create a running total calculated column that increases my amount of "dynamic assignments". I can get the measure to work when I drag it into a table but in my calculated column it just summarizes the data for all.

# Dynamic/month running total =
CALCULATE (
SUM ( Table[Dynamic/Month] ),
FILTER ( ALL ( Calendar[Date] ), Calendar[Date] <= MAX ( Calendar[Date] ) )
)

MonthYear - Dynamic/Month - Dynamic running total

Dec 2022	0	7
Nov 2022	0	7
Oct 2022	0	7
Sep 2022	0	7
Aug 2022	3	7
Jul 2022	0	7
Jun 2022	2	7
May 2022	0	7
Apr 2022	0	7
Mar 2022	1	7
Feb 2022	1	7
Jan 2022	0	7
Dec 2021	0	7
Nov 2021	0	7
Oct 2021	0	7
Sep 2021	0	7
Aug 2021	0	7
Jul 2021	0	7
Jun 2021	0	7
May 2021	0	7
Apr 2021	0	7
Mar 2021	0	7
Feb 2021	0	7
Jan 2021	0	7
Dec 2020	0	7
Nov 2020	0	7
Oct 2020	0	7
Sep 2020	0	7
Aug 2020	0	7
Jul 2020	0	7
Jun 2020	0	7
May 2020	0	7
Apr 2020	0	7
Mar 2020	0	7
Feb 2020	0	7
Jan 2020	0	7

Any help is appreciated. Thank you.

[Irwin · Accepted solution]

I think I found the answer in this thread.

https://community.powerbi.com/t5/Desktop/12-Month-Running-Total-as-calculated-column-not-measure/td-...