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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Neel98
Frequent Visitor

Cummulative Sum

Hello All,
I want to find out the cumulative sum without a date field and have attached the data for your reference. Could you please share the dax for cummulative sum?

Neel98_0-1687622218327.png

 

2 REPLIES 2
Nathaniel_C
Community Champion
Community Champion

Hi @Neel98 
Add an Index column to your table in Power Query

 

Use this if you want a total amount

Running Total = 
VAR  _tableIndex = MAX('Table'[Index])
//Var _Area = MAX('Table'[Area])

var _calc = Calculate(SUM('Table'[Quanity]),FILTER(ALL('Table'), 'Table'[Index]<=_tableIndex))
//Var _calcArea = Calculate(SUM('Table'[Quanity]),FILTER(ALL('Table'), 'Table'[Index]<=_tableIndex && 'Table'[Area]=_Area))
return _calc
Use this if you want a running total that is for each area.

Running Total Area = 
VAR  _tableIndex = MAX('Table'[Index])
Var _Area = MAX('Table'[Area])

var _calc = Calculate(SUM('Table'[Quanity]),FILTER(ALL('Table'), 'Table'[Index]<=_tableIndex))
Var _calcArea = Calculate(SUM('Table'[Quanity]),FILTER(ALL('Table'), 'Table'[Index]<=_tableIndex && 'Table'[Area]=_Area))
return _calcArea

image.png

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel


image.png





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

Proud to be a Super User!




Nathaniel_C
Community Champion
Community Champion

Hi @Neel98 ,
Would you please give us more details? Do you wish the cumulative QTY based on all the rows, or on the material or area?


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





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

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

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.