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.
I have a column in a table called duration which is in decimal format, for example, 34.60 but I need to change that to mm:ss format so instead it should be 34minutes 36 seconds , or 34:36.
How would I be able to do this?
Solved! Go to Solution.
Also, If you want to do it in Power Query, change the type of your column to Text(or create the new one as text) and then create the new column as a below :
Text.BeforeDelimiter( [Duration],".") & ":" & Number.ToText( Number.FromText( Text.AfterDelimiter( [Duration],".")) *6)
Hi,
Create the column as below :
Also, If you want to do it in Power Query, change the type of your column to Text(or create the new one as text) and then create the new column as a below :
Text.BeforeDelimiter( [Duration],".") & ":" & Number.ToText( Number.FromText( Text.AfterDelimiter( [Duration],".")) *6)
@Anonymous ,
Hi
Do you want this in DAX or Power query?
Thank you.
Power Query is fine, but what is the DAX Solution?
@Anonymous ,
Hi,
You can try following code to create new column in power query.
= Text.BeforeDelimiter( [Duration],".") & ":" & Number.ToText( Number.FromText( Text.AfterDelimiter( [Duration],".")) *0.6)
Thank you.
Error
@Anonymous
Hi
May I know the error?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |