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 everyone,
I have the following decimal number format and I need to convert it to minutes, do you know how I could do it?
For example, if we see the number 24.70 I need to convert the decimals to minutes (only the decimal value, in this case 70), it would be 70 * 0.6 = 42 minutes. The result I need is 24.42.
Thanks!
Regards
Hi @Anonymous,
I'd like to suggest you add a calculated column to re-calculated store these values:
M.Second =
INT ( Table[Value] )
+ ( Table[Value] - INT ( Table[Value] ) ) * 0.6
Regards,
Xiaoxin Sheng
@Anonymous
New column = Round([Column],0) + ( [Column] - Round([Column],0) ) * 0.6
Hello,
This metric doesn't work, since the given value is 24.82, what I'm looking for is 24.42.
This result is obtained by dividing the decimal part of 24.70 by 0.60, that is 70 / 0.60 = 42.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |