Forum Discussion
Solved
Time, List minus First, DAX Help
Hello Community, I'm trying to crack the code on DAX to subtract a previous from a next. In my example, using the data in the image, I need to subtract the 'Latest Time' from 'Run ID' 1 from the ...
Hi wayersGM
Try this measure:Measure = VAR _Start = MAX ( 'Table'[Earliest Time HrMin] ) VAR _End_Last = CALCULATE ( MAX ( 'Table'[Latest Time] ), FILTER ( ALL ( 'Table' ), 'Table'[Run ID] = MAX ( 'Table'[Run ID] ) - 1 ) ) RETURN IF ( MAX ( 'Table'[Run ID] ) - 1 = 0, BLANK (), _End_Last - _Start )
Output:If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi wayersGM
Try this measure:
Measure =
VAR _Start =
MAX ( 'Table'[Earliest Time HrMin] )
VAR _End_Last =
CALCULATE (
MAX ( 'Table'[Latest Time] ),
FILTER ( ALL ( 'Table' ), 'Table'[Run ID] = MAX ( 'Table'[Run ID] ) - 1 )
)
RETURN
IF ( MAX ( 'Table'[Run ID] ) - 1 = 0, BLANK (), _End_Last - _Start )
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
