Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Running total and sum of Running total

Hi Guys

I need DAX function for below statement.

we can easy to do running total, but after running total, how do we do sum of all running total.(Refer I column)

need dax for I coumn.

 

Capture.PNG

 

3 REPLIES 3
Anonymous
Not applicable

Please learn a bit about how to create good models in PBI and calculations:

https://www.youtube.com/watch?v=_quTwyvDfG0

https://www.youtube.com/watch?v=78d6mwR8GtA&t=1247s

Working with PBI and DAX is VERY different from Excel.

Best
D
Greg_Deckler
Super User
Super User

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thankyou dear friend, 

 

i am new to power BI and this is look so diffcult

 

i have created some DAX kindly review it

 

Running Total for Basic Salary = IF(ISFILTERED(Ddatetable[Month]),CALCULATE([Total Basic Salary],FILTER(ALL(Ddatetable),Ddatetable[Date] <= max(Ddatetable[Date]))),SUMX(SUMMARIZE(Ddatetable,Ddatetable[Month],"Sum",CALCULATE([Total Basic Salary],FILTER(ALL(Ddatetable),Ddatetable[Date] <= max(Ddatetable[Date])))),[Sum]))

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.