Forum Discussion

Sonyat810's avatar
Sonyat810
Helper III
3 years ago

Calcutate timestamp

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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.