Forum Discussion

murphm6's avatar
murphm6
Icon for Helper II rankHelper II
3 years ago

Help 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...
Need Help
Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
3 years ago

Hi murphm6 ,

I think, You might have to use  SUMX or AVERAGEX to get the rolling total

 

Regards,

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Thejeswar Did I miss them adding that function??

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    3 years ago

    Greg_Deckler ,

    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's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      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.

      • Thejeswar's avatar
        Thejeswar
        Icon for Super User rankSuper User
        3 years ago

        Greg_Deckler ,

        Sorry for creating a confusion here.😟

         

        Yes you are right... There is no such function. Not sure why gave that reply, must be some confusion that made me put that non-existing function😥

         

        I will correct it