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 hh:mm:ss: value coming in from a raw data and I'd like to convert that to mm:ss as the time value itself is below 1 hour so the "hh" part brings no value. How can I convert or remove that "hh" part? I found that in Power Query editor I can get out the minutes and second separately and might be able to combine them but that'd just put way too burden on the entire model.
Thank you!
Solved! Go to Solution.
Hi @KGBOR ,
If the column is time type, you could try this formula:
Column = FORMAT('Table'[Column1],"nn:ss")
If the column is text type, you could try this formula:
Column = RIGHT('Table'[Column1],5)
Best Regards,
Jay
Hi @KGBOR ,
If the column is time type, you could try this formula:
Column = FORMAT('Table'[Column1],"nn:ss")
If the column is text type, you could try this formula:
Column = RIGHT('Table'[Column1],5)
Best Regards,
Jay
Please see this article. The best way to handle durations is to keep them as a decimal, do your aggregations, and then format them at the end with "mm:ss".
Calculate and Format Durations in DAX – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@KGBOR , new column in power query
#time(0,Time.Minute([TimeCol]) , Time.Seconds([TimeCol]) )
Thank you @amitchandak ! For some reason it still kept the hh part at the beginning. Is there any method for such conversion?
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |