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 All,
I am trying to convert the seconds to HH:MM:SS format using "https://community.powerbi.com/t5/Desktop/How-to-convert-seconds-to-hh-mm-ss/m-p/310219#M137405" solution however ,I am getting error stating "Expression.Error: We cannot apply field access to the type Number.Details:Value=0 Key=Unit effort in Seconds".
I have used the same reference "#time(0,0,0) + #duration(0,0,0[Unit effort in Seconds])" to convert the data but it is not working.
Any help will be appreciated.
Solved! Go to Solution.
@Switto ,
New column = left([col])*3600 + mid([column],3,2)*60 + right([column],2)*1
if needed refer:https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
@Switto ,
New column = left([col])*3600 + mid([column],3,2)*60 + right([column],2)*1
if needed refer:https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
Thanks @amitchandak .
I got an error while using your suggestion, however, I tried the post you suggested and it worked 🙂
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |