TIme Duration DAX Measure error

Question

Hi Experts&nbsp;I am trying to work out the time difference between the two times and dates .&nbsp;See image of&nbsp;129 second is 00:02:09 not 00:02:29 what the second meaure is giving me&nbsp;First MeasureTime Taken in seconds = DATEDIFF(vw_fct_irs_time_taken[timestamp_created], vw_fct_irs_time_taken[timestamp_committed],SECOND)&nbsp;Then convert that to HH:MM:SS - Calculated Column&nbsp;&nbsp;&nbsp;HH:MM:SS = 
RIGHT ( "0" &amp; INT ( vw_fct_irs_time_taken[Time Taken in seconds] / 3600 ), 2 )
    &amp; ":"
    &amp; RIGHT (
        "0"
            &amp; INT ( ( vw_fct_irs_time_taken[Time Taken in seconds] - INT (vw_fct_irs_time_taken[Time Taken in seconds] / 3600 ) * 3600 ) / 60 ),
        2
    )
    &amp; ":"
    &amp; RIGHT ( "0" &amp; MOD (vw_fct_irs_time_taken[Time Taken in seconds], 3600 ), 2 )&nbsp;&nbsp;&nbsp;

greg_deckler · Accepted Answer

Anonymous&nbsp;Try this:&nbsp;Chelsie Eiden's Duration - Microsoft Power BI Community

Forum Discussion

Related content

Duration errors

notebook duration time issue

duration format

Duration format

Reset Performance analyzer- For consistent duration