compute time difference between two lines in table

You're looking for the Pivot function.

• Pivot on Position (Value is Time, and be sure not to aggregate)
• Use M to subtract the resulting in/out column values
• Convert datatype to the Duration type

Screenshots:

The line of M:

#"Added Difference" = Table.AddColumn(#"Pivoted Column", "Diff", each [out] - [in]),

Hi seb_BMW,

Alternatively, you can achieve this in DAX.

Create a calculated table based on below formula.

new table =
SUMMARIZE (
    'time difference',
    'time difference'[Nr],
    "time diff", DATEDIFF (
        MIN ( 'time difference'[time] ),
        MAX ( 'time difference'[time] ),
        SECOND
    )
)

Add a calculated column in order to format the time difference.

Column =
IF (
    'new table'[time diff] = 0,
    BLANK (),
    INT ( 'new table'[time diff] / 3600 )
        & ":"
        & INT ( MOD ( 'new table'[time diff], 3600 ) / 60 )
        & ":"
        & MOD ( MOD ( 'new table'[time diff], 3600 ), 60 )
)  

 

Best regards,
Yuliana Gu