Hold Time between 2 calls

Hi Anonymous 

You can try this code to achieve your goal.

Diff =
VAR _CurCallStart = 'Table'[Call Start]
VAR _LastCallEnd =
    CALCULATE (
        MAX ( 'Table'[Call End] ),
        FILTER (
            'Table',
            'Table'[Src] = EARLIER ( 'Table'[Src] )
                && 'Table'[Date] = EARLIER ( 'Table'[Date] )
                && 'Table'[Call End] < EARLIER ( 'Table'[Call End] )
        )
    )
VAR _TIMEDIFF = _CurCallStart - _LastCallEnd
RETURN
    IF ( _LastCallEnd = BLANK (), TIME ( 0, 0, 0 ), _TIMEDIFF )

Result is as below. Note to change the [Diff] column Data type to Time and Format to h:nn:ss.

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.