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 calculat...
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:

     

     

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: