Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |