Forum Discussion
Finding a difference between 2 columns
MBWATSON ,
a measure
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)))
For column consider earlier
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s
Thank you amitchandak. Should the result come out in hours then? Minutes? A numerical value for date/time?
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
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.
