Forum Discussion
Solved
Create Running Total On A Calculated Measure
Hi. I am trying to create a running total for a field that is defined as a Calulated Measure. Having read numerous posts I am clear about the formula struture which needs to be implemented; ...
Hi dax_bee,
Create running total using the following DAX formula and check if you get desired result.
RunningTotal = SUMX(FILTER(ALLSELECTED('Calendar'[DateKey]),'Calendar'[DateKey]<=MAX('Calendar'[DateKey])),[my_field])If the above Dax doesn’t help in your scenario, please help to share sample data of your table and post expected result.
Thanks,
Lydia Zhang
Hi dax_bee,
Create running total using the following DAX formula and check if you get desired result.
RunningTotal = SUMX(FILTER(ALLSELECTED('Calendar'[DateKey]),'Calendar'[DateKey]<=MAX('Calendar'[DateKey])),[my_field])
If the above Dax doesn’t help in your scenario, please help to share sample data of your table and post expected result.
Thanks,
Lydia Zhang
- Many thanks for sharing this. Helped big time. I hope you wont mind answering one quick question? When I used this formula, the cumulative total continues to show constant value throughout the x axis even if there is zero value for the later groups. How can we stop running total from continuing all the way? Please advise. Thanks
Thank you for all your help.
v-yuezhe-msft - your solution worked a treat!
Hello everyone, I have to calculate cumulative sum for distinct Ben per day in order to obtain this
My table have these columns:
THanks a lot. I also had same query .
