Forum Discussion
Dellis81
Post Prodigy
Post ProdigySumX? - cumulative running total
Hello I am in need of help with a running total calculation. I am wanting to derive formula that calculates cumulative animal days based on animal inventory over a specified calendar interval. ...
lbendlin Ashish_Mathur v-prasare
Guess what - think I got the problematic measure to work :). I remain confused in many areas of DAX - but I can move forward now. Thank you to all three of you for your suggestions.
My solution was to place Animal Days in a SumX iterator - and that resulted in the group total work, as well as the cumulative animal day measure. Something simple, but yet so confusing.
=Var ReportValue = SUMX(VALUES('Calendar'[Dates]),[End Animal Inventory Quantity]) return ReportValue
lbendlin
Super User
Super UserFirst port of call should be the Quick Measure for the Running Total scenario. Have you given that a try?
Once you have seen that code you can "improve" it by using WINDOW(1,ABS,0,REL,..)