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.
Hello,
I am new to PowerBI. I have a column in PowerQuery named "Media Elapsed Time Text" which contains the values of time elapsed in Text format d.hh:mm (Days.Hours:Minutes) as shown below:
I need to convert it into the format of hh:mm:ss (Hours:Minutes:Seconds). As seconds are not mentioned in the initial data seconds can be "00". But I need to transform the mentioned column from Days to Hours fromat. So for e.g '1d.13:42' will become '37:42' (1d = 24 hours, adding them to 13:42 becomes 37:42).
Is there any way I can perform it in PowerQuery..? Any help on this will be appreciated.
Thank you
Hi ,time format should be 0 > 24. it is impossible to your expectation. I think you only show your expected result by text format. Use functions like LEFT, RIGHT, MID to take number of days, then convert ti to number and multiply 24, add number of hour (already convert to number). End, you combine with number of minutes under text type as you want.
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 | |
98 | |
79 | |
66 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |