Rolling next 8-week average

Hi,

I am not sure how your data model looks like, but I assume you have a calendar table like below.

I tried to create a sample pbix file like below, and please check the below picure and the attached pbix file.

Demand measure: = 
SUM( Data[Demand] )

Expected result measure: =
VAR _condition =
    DIVIDE ( [Demand measure:], [Demand measure:] )
RETURN
    IF (
        HASONEVALUE ( 'Calendar'[Year-Wk] ),
        _condition
            * AVERAGEX (
                ADDCOLUMNS (
                    WINDOW (
                        1,
                        REL,
                        8,
                        REL,
                        ALL ( 'Calendar'[Year-Wk], 'Calendar'[Start of Week] )
                    ),
                    "@demand", [Demand measure:]
                ),
                [@demand]
            )
    )

hi Anonymous 

you may also try to add a column like this:

Avg_Demand2 = 
VAR _week = WEEKNUM([Week])
RETURN
AVERAGEX(
    FILTER(
        TableName, 
        WEEKNUM(TableName[Week])<=_week+8
            &&WEEKNUM(TableName[Week])>_week
    ),
    TableName[Demand]
)

it worked like this:

Hope this helps