Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Morning All,
I have been stuck on cumulative total formula for weeks now. I have done exhaustive research on this forum but none of the selected solutions worked for me. Any help or tips are greatly appreciated. Thank you in advance.
--------------------------------------------------------------------------------------------
I need to calculate a cumulative sum of products sold since 2003. My dataset only comprises 196 rows though. Each product has an order type which I filtered by first using the following formula:
Solved! Go to Solution.
What you are doing right now seems very unneccesary to me.
The following measure should do the trick.
Running Total MEASURE =
CALCULATE (
[Expression],
FILTER (
ALL ( 'table' ),
'table'[Date] <= MAX ( 'Table'[Date] )
)
)
It will evaluate all data in your data set that is smaller than the axis you use the visualize the data.
Kind regards
Joren Venema
Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.
Hi @brightcitrus ,
Do you try that formula? Does it work? If you have solved the issue, please accept the helpful answers to solutions. If you solved by yourself, welcome to share to us. More people who encounter the same problem will benefit here.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @brightcitrus ,
The formula that Joren venema suggested should work. I add some blogs and video that you could learn from.
DAX for Power BI - Running Total (Cumulative Sum)
Calculate Cumulative/Running Total In Power BI
Computing running totals in DAX
If the answers can't solve your problem, please share some sample data and your expected result. Then we will understand clearly and solve it quickly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What you are doing right now seems very unneccesary to me.
The following measure should do the trick.
Running Total MEASURE =
CALCULATE (
[Expression],
FILTER (
ALL ( 'table' ),
'table'[Date] <= MAX ( 'Table'[Date] )
)
)
It will evaluate all data in your data set that is smaller than the axis you use the visualize the data.
Kind regards
Joren Venema
Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |