Using DATEDIFF to calculate (hh:mm)

[cmiller1221]

I am trying to find the difference in time down to the hour and minute. Here is an example of some of the data.

I cant seem to write a DAX statement that allows me to output the hours and minutes elapsed between the two columns. One problem I am running into with the HOUR feature is that it maxes at 23 hours. Any help would be appreciated. 

[amitchandak]

@cmiller1221 , you date diff between

Date1 - Date2 = it will be in time, more than 24 hours will in day

if you try datediff(Date1,Date2,Minute), You need convert into hours and minute using Mod and quotient and display as text

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[az38]

Hi @cmiller1221 

try smth like

Column = 
var diff = VALUE([ResolvedDate] - [DiscoveredDate])
var h = ROUNDDOWN(24 * diff, 0)
var m = ROUNDDOWN(60* (24 * diff - h), 0)
RETURN
h & "h " & m & "m"