Forum Discussion
Post ProdigySumX? - cumulative running total
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
Super UserHi,
This DAX measure pattern should work
Measure = calculate([animal days],datesbetween(calendar[date],minx(all(calendar),calendar[date]),max(calendar[date])))
Hope this helps.
Post Prodigythank you for your response. Makes sense.
I am travelling this week, home tomorrow evening. I will review first opportunitiy that i have quality focus time
Thank you, and will be in touch