Calculating Moving Range

[JamesSPBI]

Hi all, 

Need a little help with working this out please. 

Trying to calculate the moving range between a month and the previous month over a dataset (roughly 18 months). I have been using the below, but after testing it appears to be wrong.

MovingRange = ABS([Metric]-CALCULATE([Metric],PARALLELPERIOD(DateTable[StartOfMonthDate],-1,MONTH),ALL(DateTable)))

Any suggestions would be really appreciated!

[bhanu_gautam · Accepted solution]

@JamesSPBI , Try updating measure as

MovingRange =
VAR CurrentMetric = [Metric]
VAR PreviousMetric = CALCULATE(
[Metric],
PARALLELPERIOD(DateTable[StartOfMonthDate], -1, MONTH)
)
RETURN
ABS(CurrentMetric - PreviousMetric)

[mickey64]

To use the time intelligence functions, you must create a calendar table.