To Find the rolling Average of previous 3 months.

[SaChinKuMarT]

https://docs.google.com/spreadsheets/d/1tr6Ueydn3xLod-KSIa5bJHd6KMHbr72O/edit?usp=sharing&ouid=11425.... 

So what I need is that the rolling average of previous 3 months with the Count of cust_id. Then so i am expecting the result like if i press on the April month means it should show the previous 3months rolling average that is (march+feb+jan). Again if click on the May  month means it should show the rolling average of (april+march+feb).

Kindly please help me with your ideas.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[SaChinKuMarT]

Thank you so much sir it worked. 🙂

[Ashish_Mathur]

You are welcome.