cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Irwin
Advocate II
Advocate II

Running total in calculated column

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] ) )
)

 

Irwin_1-1643198152276.png

MonthYear - Dynamic/Month - Dynamic running total

Dec 2022      07
Nov 202207
Oct 202207
Sep 202207
Aug 202237
Jul 202207
Jun 202227
May 202207
Apr 202207
Mar 202217
Feb 202217
Jan 202207
Dec 202107
Nov 202107
Oct 202107
Sep 202107
Aug 202107
Jul 202107
Jun 202107
May 202107
Apr 202107
Mar 202107
Feb 202107
Jan 202107
Dec 202007
Nov 202007
Oct 202007
Sep 202007
Aug 202007
Jul 202007
Jun 202007
May 202007
Apr 202007
Mar 202007
Feb 202007
Jan 202007

 

 

Any help is appreciated. Thank you.

1 ACCEPTED SOLUTION
Irwin
Advocate II
Advocate II
1 REPLY 1
Irwin
Advocate II
Advocate II

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!