Forum Discussion
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
Thankyou in advance
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)
5 Replies
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.
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 ,
[Date1]-[date2] will give duarion
datediff([Date1],[Date2], hour) will give diff in hours
kenblack - If you need net work duration, you can use this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Duration-Working-Hours/m-p/481543#M182
