Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Using a commonly shared dax to convert seconds to Hours/Minutes/Seconds. Have used this before, but for some reason, it doesn't seem to be converting correctly? I'm looking at an average call time and this is the example:
Total Call Time - 5,791,498 (sec)
Total Calls - 11,252
Avg Call Time = 514.71 sec
Just using an online converter, the Avg Call Time converts to 08:58 (rounded up)
But when I use the Dax converter, it's giving me 08:35? Am I looking at this wrong? Below is the DAX.
Solved! Go to Solution.
using an online converter, the Avg Call Time converts to 08:58 (rounded up)
No, that's not what it converts to. It converts to 8.5785 . It is a decimal value, not a hexagesimal value. When you multiply .5785 by 60 you get 34.71. So your conversion equivalent would be 8:35.
using an online converter, the Avg Call Time converts to 08:58 (rounded up)
No, that's not what it converts to. It converts to 8.5785 . It is a decimal value, not a hexagesimal value. When you multiply .5785 by 60 you get 34.71. So your conversion equivalent would be 8:35.
Ahhh...okay thank you!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |