Forum Discussion

Helper II

4 years ago

Find difference between 2 rows

DateTime SerialId GenHours Difference 9/22/2020 18:04 M3501-118 4789 blank 4/12/2021 18:19 M3501-118 5047 258 5/5/2021 14:28 M3501-118 5047 0 6/17/2021 15:10 M...

Data Protection

AlexisOlson

Super User

4 years ago

Ah, I didn't realize you were looking for a DAX solution. That's actually a bit easier.

Try this:

Difference = 
VAR CurrDateTime = SELECTEDVALUE ( Merge1[DateTime] )
VAR PrevDateTime = CALCULATE ( MAX ( Merge1[DateTime] ), Merge1[DateTime] < CurrDateTime )
VAR PriorGenHours = CALCULATE ( [Gen Hours], Merge1[DateTime] = PrevDateTime )
RETURN
    IF ( NOT ISBLANK ( PriorGenHours ), ABS ( [Gen Hours] - PriorGenHours ) )