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.
In Power Query i have a column which, for example looks like this
9h8m4s
this means 9 hours, 8 minute and 4 second. the challenge now is that i want to convert this value in the column to be the sum up of the hour, minute and second to be only second which actually equals to 32884 seconds.
and ideas about how to convert it in PowerQuery for Power Bi?
Solved! Go to Solution.
@Anonymous
here is a workaround for you. pls see the attachment below
Proud to be a Super User!
oh man, that was so simple and amazing. i was trying to do the same idea but i stuck with "how am i going to do a calucations within the columns" but luckily "Expression.Evaluate" saved the day. thank you so much for your help ❤️
you are welcome
Proud to be a Super User!
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |