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...
devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

TimeDifference = FORMAT([EndTime] - [StartTime], "hh:mm:ss")

 

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

    Hi devanshi , 

    This with this is, Between start and end date ia have gap of days also.