Forum Discussion

Taro_Gulat's avatar
Taro_Gulat
Regular Visitor
1 year ago
Solved

Timestamp Difference

Hi all, 

 

I am having difficulty in calculating the difference between two timestamp when start and end days are different. For the same day it is working. 

In above case i need to calculate time difference between start and end for each step. The result should be in HH:MM:SS format. 

 

Can anyone help?

Thanks

Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    Hi Taro_Gulat ,
    Create a new calculated column in your table using this DAX:

    TimeDifference = 
VAR TotalSeconds = DATEDIFF('Table'[Start], 'Table'[End], SECOND)
VAR Hours = INT(TotalSeconds / 3600)
VAR Minutes = INT(MOD(TotalSeconds, 3600) / 60)
VAR Seconds = MOD(TotalSeconds, 60)
RETURN 
FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00") & ":" & FORMAT(Seconds, "00")

     

    Your final result will look like this:

     

     

1 Reply

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    Hi Taro_Gulat ,
    Create a new calculated column in your table using this DAX:

    TimeDifference = 
VAR TotalSeconds = DATEDIFF('Table'[Start], 'Table'[End], SECOND)
VAR Hours = INT(TotalSeconds / 3600)
VAR Minutes = INT(MOD(TotalSeconds, 3600) / 60)
VAR Seconds = MOD(TotalSeconds, 60)
RETURN 
FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00") & ":" & FORMAT(Seconds, "00")

     

    Your final result will look like this: