Forum Discussion
Solved
calculating duration
I have two columns both in the following format 04/06/2020 05:02:00 so dd/mm/yyyy hh/mm/ss and I would like to subtract one from the other to get the duration in hrs - can anyone help please ...
Use the Duration.TotalHours() function in Power Query. Just subtract column 1 from column 2. It will return total and fractional hours.
If you just need hours, round it using Number.Round(formula, 0)
kenblack You can also do this in DAX with the DATEDIFF function https://docs.microsoft.com/en-us/dax/datediff-function-dax
Hours Difference = DATEDIFF([Start],[End],HOUR)
Yes, if you need this in a measure, DATEDIFF() will work well. If you need a column, Power Query is generally a better choice for performance than a calculated column. So depends on how you are using this.