topic Using DATEDIFF to calculate (hh:mm) in DAX Commands and Tips

Using DATEDIFF to calculate (hh:mm)

cmiller1221 — Tue, 14 Jul 2020 21:08:36 GMT

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.

Re: Using DATEDIFF to calculate (hh:mm)

az38 — Tue, 14 Jul 2020 22:02:48 GMT

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"

Re: Using DATEDIFF to calculate (hh:mm)

amitchandak — Wed, 15 Jul 2020 03:00:11 GMT

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-using-dax

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