Forum Discussion

vdomingueza's avatar
vdomingueza
New Member
9 years ago

Moving Average on weeks

Hi everyone,    I'm trying to calculate moving average on 4 weeks like an Excel formula. The excel formula is calculated as a TAM(Moving Average) in Excel .    The dates are the following :    ...
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

create a measure

 

 

Moving_Average_4_weeks = 
CALCULATE (
    AVERAGEX ( 'table', 'table'[valor] ),
    DATESINPERIOD (
        'table'[date]
        LASTDATE ( 'table'[date] ),
        -4,
        week
    )
)

give this a bash vdomingueza