power bi time difference

Hi drad2211 

az38's measure works.

Time Diff =
VAR LastTimeIn =
    CALCULATE (
        MAX ( Table1[Time] ),
        FILTER (
            ALL ( Table1 ),
            Table1[Action] = "In"
                && Table1[ID] = SELECTEDVALUE ( Table1[ID] )
                && Table1[Time] < SELECTEDVALUE ( 'Table1'[Time] )
        )
    )
RETURN
    IF (
        SELECTEDVALUE ( Table1[Action] ) = "Out",
        DATEDIFF ( LastTimeIn, SELECTEDVALUE ( Table1[Time] ), MINUTE ),
        ""
    )

Since Measure doesn't stored in the data model and it can't be used as a item in a slicer,

if you want to create a calculated column, you could create a column like this:

Column =
VAR last_ =
    CALCULATE (
        MAX ( Table1[Time] ),
        FILTER (
            Table1,
            Table1[ID] = EARLIER ( Table1[ID] )
                && Table1[Action] = "In"
                && Table1[Time] < EARLIER ( Table1[Time] )
        )
    )
RETURN
    IF ( [Action] = "Out", DATEDIFF ( last_, [Time], MINUTE ) )

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.