Calculating Moving Average at rolling monthly bases

[ljx0648]

Hi everyone, 

I am trying to create a measure to calculate moving average sales - the moving average is not fixed but base on the month into the year.

The sample data + highlighted expected result as per attached:

Any tips would be appreciated!

Thank you

[Greg_Deckler · Accepted solution]

@ljx0648 Try this: Better Rolling Average - Microsoft Power BI Community

[anushaghi123]

Hi, For each product data, create data as a moving average of the last 4 months.

For example: US Product_Name April, May, June, July are 1683,1668,776,1885. So Predict Aug as Average of the 4, then use average of May, June July, Aug as September.  And  a slider that can be used to do -20% to +20%. That means, to 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.

Thanks