Forum Discussion

MBWATSON's avatar
MBWATSON
Helper II
3 years ago

Finding a difference between 2 columns

Good morning,   I have a table with a column titled Status Audit Type. Two of the values in this column are Create and Done and each has a corresponding date/time in another column Titled Status Ch...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

MBWATSON , datediff you can get in hour, minute, second , day

 

if you need get time, simply date diff two, but that will not sum

 

You can try like

 

time(0,0,0) + sumx( Values(Table[message ID]), calculate(datediff(minx(filter(Table, Table[Status Audit Type] ="Create"), Table[Status Changed at]), maxx(filter(Table, Table[Status Audit Type] ="Done"), Table[Status Changed at]), hour)))/24

MBWATSON's avatar
MBWATSON
Helper II
3 years ago

Maybe I should clarify, I am looking for the amount of time it took to complete the work, from the create time to the done time.  When I try the second formula I get an error message.

  • MBWATSON's avatar
    MBWATSON
    Helper II
    3 years ago

    I found the error so that isn't an issue. The formula returns a date and time. What I need is for it to return HH:MM

    • MBWATSON's avatar
      MBWATSON
      Helper II
      3 years ago

      amitchandak I was able to get this to show a time but they aren't correct. I have a Create date/time of 4/19/2022 8:20:09 and a Done date/time of 10/31/22 6:17:17 that doesn't even show in the Matrix. Some with similar dates/times showing in the Matrix as 7 hours. Any other suggestions?