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.
Hi
how to write dax query between two dates , finding the hours and mins in same column?
Thanks
kunuthuri
Solved! Go to Solution.
Hi @Anonymous,
The new calculated column is Text data type.
hour/min = IF ( DATEDIFF ( data[startdate], data[enddate], HOUR ) = 0, FORMAT ( DATEDIFF ( data[startdate], data[enddate], MINUTE ), "" ), DATEDIFF ( data[startdate], data[enddate], HOUR ) & "." & ( DATEDIFF ( data[startdate], data[enddate], MINUTE ) - DATEDIFF ( data[startdate], data[enddate], HOUR ) * 60 ) ) & "mins"
Best regards,
Yuliana Gu
Hi @Anonymous,
The new calculated column is Text data type.
hour/min = IF ( DATEDIFF ( data[startdate], data[enddate], HOUR ) = 0, FORMAT ( DATEDIFF ( data[startdate], data[enddate], MINUTE ), "" ), DATEDIFF ( data[startdate], data[enddate], HOUR ) & "." & ( DATEDIFF ( data[startdate], data[enddate], MINUTE ) - DATEDIFF ( data[startdate], data[enddate], HOUR ) * 60 ) ) & "mins"
Best regards,
Yuliana Gu
Hi
Thanks to replay.
It displaying hours and minutes,
startdate end date hour/min
3/18/2012 7:00:00 AM 3/18/2012 8:05:00 AM 1.65 min
but my requirement is hours with minutes
startdate end date hour/min
3/18/2012 7:00:00 AM 3/18/2012 8:05:00 AM 1.05 min
can you please assist?
Kunuthuri
Hi @Anonymous,
With my above DAX formula, you could get the result "hours with minutes".
Best regards,
Yuliana Gu
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |