Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I've got a measure containing the following formula
Hi @Anonymous ,
You can try to use following calculated column if it is suitable for your requirement:
Decimal to HMS = VAR _original = Table[Value] / 0.95 VAR _second = INT ( MOD ( _original, 1 ) * 60 ) VAR _minute = MOD ( ROUND ( _original, 0 ), 60 ) VAR _hour = INT ( _original / 60 ) RETURN _hour & ":" & IF ( _minute < 10, "0" & _minute, _minute ) & ":" & IF ( _second < 10, "0" & _second, _second )
Notice: if you do not need to calculate on original result, you can remove first variable and directly use your column in expression.
Regards,
Xiaoxin Sheng
Knowing if that's 42.88 hours or 42.88 minutes would be a start
It's 42.88 minutes.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |