calculating duration

[kenblack]

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 

[Greg_Deckler]

@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#M...

[amitchandak]

@kenblack ,

[Date1]-[date2] will give duarion

datediff([Date1],[Date2], hour) will give diff in hours

[DataZoe]

@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)

[edhans]

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.

[edhans · Accepted solution]

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)