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