Forum Discussion

rautaniket0077's avatar
rautaniket0077
Icon for Resolver I rankResolver I
3 years ago

difference between 2 datetime columns in hr:mm:ss

Hi Team, I am using direct query mode and I want the difference between 2 datetime columns in hr:mm:ss using DAX The DAX I am using right now is Duration HH:MM:SS = // We start with a duration in...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi rautaniket0077 
You can try

 

Duration HH:MM:SS =
MAXX ( 'Table', 'Table'[EndDate] - 'Table'[StartDate] )

 

And then select (Long Time) format

Or you can use TIMEVALUE function as follows

Duration HH:MM:SS =
TIMEVALUE( MAXX ( 'Table', 'Table'[EndDate] - 'Table'[StartDate] ) )

 

 

  • rautaniket0077's avatar
    rautaniket0077
    Icon for Resolver I rankResolver I
    3 years ago

    Hi tamerj1 ,

    facing below error

    error -- operator does not exist: inter-timestamp without timezone

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      rautaniket0077 

      Would you please share a screenshot that shows the dax code along with the error 

      • rautaniket0077's avatar
        rautaniket0077
        Icon for Resolver I rankResolver I
        3 years ago

        Actually no as report is on client side

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      rautaniket0077 

      Ok, then try

      Duration HH:MM:SS =
      FORMAT ( MAXX ( 'Table', 'Table'[EndDate] - 'Table'[StartDate] ), "HH:MM:SS" )