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.
Good afternoon,
I was using a database in Power BI with some durations but I had a problem. The format is a time format like this one : HH:MM:SS and not a duration. And I would like to get a format which permits me to do different calculations as average.
Here is the example : 00:12:00 (time format) and I would like to get 12,00. When I change the format and I choose Duration, it shows me an error.
Do you know how to make this transformation without created a new column please ?
Solved! Go to Solution.
HI @JonathanJohns,
Power bi not support duration type, I'd like to suggest you convert it as total second or other similar numeric value to calculate.
You can also take a look at below blog to know how to handle with duration in power bi:
Regards,
Xiaoxin Sheng
HI @JonathanJohns,
Power bi not support duration type, I'd like to suggest you convert it as total second or other similar numeric value to calculate.
You can also take a look at below blog to know how to handle with duration in power bi:
Regards,
Xiaoxin Sheng
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 |
---|---|
114 | |
99 | |
81 | |
70 | |
61 |
User | Count |
---|---|
148 | |
116 | |
104 | |
89 | |
65 |