Forum Discussion
Solved
Calculating Moving Range
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 th...
JamesSPBI , Try updating measure as
MovingRange =
VAR CurrentMetric = [Metric]
VAR PreviousMetric = CALCULATE(
[Metric],
PARALLELPERIOD(DateTable[StartOfMonthDate], -1, MONTH)
)
RETURN
ABS(CurrentMetric - PreviousMetric)
JamesSPBI , Try updating measure as
MovingRange =
VAR CurrentMetric = [Metric]
VAR PreviousMetric = CALCULATE(
[Metric],
PARALLELPERIOD(DateTable[StartOfMonthDate], -1, MONTH)
)
RETURN
ABS(CurrentMetric - PreviousMetric)