The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
32 |
User | Count |
---|---|
96 | |
75 | |
67 | |
52 | |
52 |