Moving average Value in weeks

[Anonymous]

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

[Anonymous]

@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. 

[Baskar]

Cool , try this it will help u .

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

[Anonymous]

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 · Accepted solution]

Cool my dear friend ,pls close the ticket