Forum Discussion

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
1 year 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
    1 year 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
Icon for Super User rankSuper User
1 year ago

Not clear which sheet contains your source data and which is the expected result. Can you please clarify.

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
1 year ago

I'm sorry!

Sheet 6(2) is my pivot table summary with Dax measures.   The remaining tabs are either source data or misc tabs in my process.

I think you had mentioned using the windows function.   Are those available in Excel?   I am needing to keep inside excel for additional analysis and printing functions.

 

Thank YOU!

thank you!