Get the Time Difference

Hi Leslie1015 ,

Calculated column:

Output 2 = 
VAR CurrentID = TableName[ID]
VAR CurrentIndex = TableName[Index]
VAR CurrentDate = TableName[Date]
VAR PreviousRow = 
    CALCULATE (
        MAX ( TableName[Date] ),
        ALLEXCEPT ( TableName, TableName[ID] ),
        TableName[Index] = CurrentIndex - 1
    )
RETURN
IF (
    CurrentIndex > 1,
    CurrentDate - PreviousRow,
    BLANK ()
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum