rolling average/sum of weekly sales

[akfir]

i wish to create a weekly rolling average measure.
My sales data is daily and contains sales of 2018-2019 (accumulative).
notice that last x weeks could contain the last of 2018 and the first of 2019 (sorting issues)
Thanks!!

[Mariusz]

Hi @akfir 

Try something like.

Measure 8 = 
CALCULATE(
    AVERAGEX( VALUES( 'Calendar'[Date] ), [Sales] ), -- or AVERAGE( Sales[Quantity] )
    DATESINPERIOD( 'Calendar'[Date], MAX( 'Calendar'[Date] ), -7, DAY )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.