Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to get moving average on monthly

HI, all I'd like to get monthly moving average by making measure as below, but it may not work well Could you please help me ------------------------------------------------------------ <Me...
Need Help
mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Anonymous ,

try this measure

Moving Average Last 2 Months = 
VAR _MaxMonth = MAX('Date'[Year*Month])
RETURN
CALCULATE(AVERAGEX('Facts5','Facts5'[Sales]),
           'Date'[Year*Month]>= _MaxMonth -1 && 'Date'[Year*Month] <= _MaxMonth
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.