Forum Discussion
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...
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
Throwing this back out there 🙂
The suggested formula for the measure did not work. Here is an example
This particular message took almost a year to complete. Yet here is the cycle time using the formula shown in hh:mm format
Any other suggestions amitchandak or anyone else?