Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
10 months ago
Solved

SumX? - 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. ...
Need Help
  • Dellis81's avatar
    Dellis81
    9 months ago

    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's avatar
lbendlin
Super User
9 months ago

Which one of these tabs contains the actual source data?  How is "Consolidated"  computed?

Dellis81's avatar
Dellis81
Post Prodigy
9 months ago

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.