Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rolling next 8-week average

Hi all,   I was struggling to figure out how to get an average demand from next 8 weeks, if the remainging weeks are less than 8 weeks, then calculate average based on the number of remaining weeks...
Need Help
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

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:

  • Padycosmos's avatar
    Padycosmos
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hope this helps