Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
105 | |
101 | |
81 | |
79 | |
67 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |