Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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
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
Proud to be a Super User!
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
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |