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 UserToo may tabs and too many measures creating more confusion than clarity. Share a much smaller dataset with only the information which is necessary. Show the expected result and calculation logic there.
Post Prodigy
Hello, I've attempted to cleanup/simplify the spreadsheet to only relevant measures. I have moved all the required measures to a _measures table. The hilighted measures are related to the problematice Animal Day calculation.
Below is the excel pivot table I am working with. Column I (in green) is my desired result for Column F (cumulative animal days). The measures relating to "Feed Fed" are working as expected - with equivalent DAX pattern for Animal Days Cumulative.
And just to be safe - including a new link.
https://drive.google.com/drive/folders/1-dKYRdtfqyVYNsHLCZrLO_v08gaUFruI?usp=drive_link
I do appreciate your help - and apologize for not being clear and concise in my communications.
thank you!
- lbendlin
Which one of these tabs contains the actual source data? How is "Consolidated" computed?
- Dellis81
To answer your question (I think) - Excel PowerQuery transforms the two "dump" tabs together and computes the Consolidated Table which is then loaded into the excel data model.
DAX measures are then the "values" within Power Pivot table (tab Animal Day calc). These power queries and Data Model loading should be accessable in the file.
