Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need help calculating Moving Average on Aggregate level based on non date fields

Hello Team,    I have a dataset which consists of 48 weeks of data for each subscriber. I would like to calculate 4 rolling average by week (aggregated by week for all subscribers. i.e. Week 1 sum ...
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous ,

 

Try this measure:

 

_MA_4 Weeks = 
VAR _week = SELECTEDVALUE('Table'[Week ])
RETURN
    AVERAGEX(
        SUMMARIZE(
            FILTER(
                ALL('Table'), 
                'Table'[Week ] >= _week - 3 && 'Table'[Week ] <= _week
            ), 'Table'[Week ], 
        "Total", SUM('Table'[Sales])
        ), 
    [Total]
)