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 Dellis81 ,
i have modified the first measure in my solution.
please give it a try and let me know.
Thanks and Regards,
Praful
Post ProdigyHello
I believe the existing measure currently in place is equivalent to your new suggestion.
Any other thoughts? Thank you!
=Var ReportValue = [End Animal Inventory Quantity]
return
ReportValue- Dellis81
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