6 Month Rolling Average/Median Help

[Anonymous]

Hello,

I am trying to figure out how to create a 6 month rolling average and/or median. I have one dataset I am working with. I have a measure for the total number of pieces and the sum for the total price. What I am trying to find is what is the rolling average price for pieces are. 

Appreciate any help that can be provided. 

Thanks!

[FreemanZ · Accepted solution]

hi @Anonymous 

try like:

6MonthAvg =

CALCULATE(  

    DIVIDE([PriceTotal], [PieceTotal]),

    DATESINPERIOD(

        'Date'[Date],

        MAX('Date'[Date]),

        -6,MONTH

    )

)

this is a measure to be plotted with the date[date] column

[anushaghi123]

Hi,  Need help with the following question 

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

For example: United States 37101 April, May, June, July are 1683,1668,776,1885. 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%.  Where we cn check forecast  in case we go -1% of the moving average or 5% of the moving average.

Thanks