7 Days Rolling Average between 2016-2020

[parminderkellah]

Hi Experts

The below measure gives me the correct average calculation for the period 2016-2020. How do i get the 7 day rolling average between thsoe dates

my Measure =

2016-20 Average =

VAR _A =  SELECTEDVALUE(DimDate[Day of Year])

RETURN

        CALCULATE(

                Average('ce DemandDestructionSimple'[Value]),

                    DimDate[Day of Year] = _A,

            DimDate[Year] >= 2016 && DimDate[Year] <= 2020,

    ALL( DimDate )

)

[parminderkellah]

My new Measure

7 Days Rolling Average (2016-20) =

VAR _A =  SELECTEDVALUE(DimDate[Day of Year])

VAR _Rolling=  CALCULATE(

                Average('ce DemandDestructionSimple'[Value]),

                    DimDate[Day of Year] = _A,

            DimDate[Year] >= 2016 && DimDate[Year] <= 2020,

                                ALL( DimDate )

        )

VAR _Result =

        CALCULATE(_Rolling,

             DATESINPERIOD(DimDate[Date],LASTDATE(DimDate[Date]),-7,DAY))

Return

    _Result

[grandtotal · Accepted solution]

Check out this article by SQLBI:

https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/