Forum Discussion
murphm6
Helper II
Helper IIHelp calculating 12 month trailing sum in table
Hi all, i want to calculate a twelve month trailing sum of the volume column for each individual prod pkg code - how can i do this? I've tried doing CALCULATE(SUM('Table' [Vol(CUR]), DATESINPERIO...
Thejeswar
Super User
Super User- Greg_Deckler
Community Champion
Thejeswar Did I miss them adding that function??
- Thejeswar
Not sure on your ask. As murphm6 was asking for getting the prior 12 months number, I thought RunningTotal() should be an appropriate thing for it. But I see you have suggested a different approach for this. If that works for Rolling Totals, I am good to know it for my future use.
In your response, what I was not sure is, Why do you have to use AVERAGEX over SUMX to get the Rolling Sum.
And, BTW, in my response, I had earlier wrongly mentioned as Rolling Average in place of Rolling Sum
- Greg_Deckler
Thejeswar I'm just not aware that a RUNNINGTOTAL function actually exists in DAX. If it does, it doesn't show up in my intellisense and there is no documentation on it anywhere that I find.
