Calcutate timestamp

[Sonyat810]

I'm trying to calculate the difference between timestamp. My code isn't working.

[Anonymous]

Hi @Sonyat810 ,

Due to I don't know your data model, here I will create a sample to have a test.

Measure:

Diff between Timestamp =
VAR _DIFFSECOND =
    DATEDIFF ( MAX ( 'Table'[Start] ), MAX ( 'Table'[End] ), SECOND )
VAR _HOUR =
    FORMAT ( QUOTIENT ( _DIFFSECOND, 60 * 60 ), "00" )
VAR _MINUTE =
    FORMAT ( QUOTIENT ( _DIFFSECOND - _HOUR * 60 * 60, 60 ), "00" )
VAR _SECOND =
    FORMAT ( _DIFFSECOND - _HOUR * 60 * 60 - _MINUTE * 60, "00" )
RETURN
    COMBINEVALUES ( ":", _HOUR, _MINUTE, _SECOND )

Result is as below.

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.

[Sonyat810]

[Sonyat810]

How do I attach my .pbix file?