Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure Difference When Value = Value - 1

I have a measure, CRT, that is being displayed over an interval of every 30 minutes time. to make things easier I've attached an interval ID number that represents every 30 minutes of the day.    I...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you so much for the quick reply. 

 

Unfortunately that's giving me the same result.

 

 

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago
CRT Difference =
VAR PrevCRT =
CALCULATE(IntraCRT[CRT],
FILTER(ALL(DAXIntervalID[Value]),
    DAXIntervalID[Value] = MAX(DAXIntervalID[Value]) -1)
)
VAR CurrentCRT = IntraCRT[CRT]
RETURN
    PrevCRT - CurrentCRT