Calculate Dynamic Rolling Average in PowerBI using a Slider | MiTutorials

Hi, For each product, how to calculate moving average of the last 4 months.
For example: US product data for April, May, June, July are 1683,1668,776,1885. So Aug as Average of the 4, then average of May, June July, Aug as September. And a slider that can be used to do -20% to +20%. Means check what the forecast will be in case we go -1% of the moving average or 5% of the moving average. Could you please suggest a solution for this. Thanks.

Pretty impressive. Can this also be done on an excel pivot table using dax data model pivot table)?

Thank you very usefull...

very Nice Tutorial as usual, Can you please make a video on how to give ranking to multiple columns using Rankx function