Forum Discussion

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
11 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
    11 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

     

v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
11 months ago

Hi Dellis81,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.


Ashish_Mathur & lbendlin ,Thanks for your prompt response

 

 

 

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
11 months ago

Good Morning!

Back from my travel.   I just responded to Ashish with his most recent thoughts.

Appreciate your responses - I should be more available next 2 weeks.

 

thank you!