Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Moving average Value in weeks

Hi PBI, After reading countless suggestions from the web, I am unable to resolve a "weekly moving average" calculation. In the screen shot, I have the weekly Orders. I am trying to calculate the moving 3 weeks average. The formula i created (Red section) is wrong.

My data has total Orders at the end of each week - in this case Sunday. I am scratching the scalp off my head.. Thanks in advance

Need Help
  • Baskar's avatar
    Baskar
    9 years ago

    Cool my dear friend ,pls close the ticket 

4 Replies

  • Baskar's avatar
    Baskar
    Resident Rockstar
    9 years ago

    Cool , try this it will help u .

     

    if not let me know i will help u my dear friend .

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      hi Baskar, it didnt quite worked out but looking at your idea, I understand the concept a LOT LOT better and applied to another apporach using DATESBETWEEN- which worked! I would not have come to this without your help.. Thank you.. Case close ...for now 

      • Baskar's avatar
        Baskar
        Resident Rockstar
        9 years ago

        Cool my dear friend ,pls close the ticket 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Baskar  Can you please let me know the DAX function I am also having requirement. Output of the rolling average should start from wk4.

    Thanks in advance.