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 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!
JamesSPBI , Try updating measure as
MovingRange =
VAR CurrentMetric = [Metric]
VAR PreviousMetric = CALCULATE(
[Metric],
PARALLELPERIOD(DateTable[StartOfMonthDate], -1, MONTH)
)
RETURN
ABS(CurrentMetric - PreviousMetric)
2 Replies
JamesSPBI , Try updating measure as
MovingRange =
VAR CurrentMetric = [Metric]
VAR PreviousMetric = CALCULATE(
[Metric],
PARALLELPERIOD(DateTable[StartOfMonthDate], -1, MONTH)
)
RETURN
ABS(CurrentMetric - PreviousMetric)To use the time intelligence functions, you must create a calendar table.
