Forum Discussion
MBWATSON
Helper II
Helper IIFinding 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...
amitchandak
Super User
Super UserMBWATSON , 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
MBWATSONHelper II
Helper IIMaybe 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.