Forum Discussion
Duration format
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 ?
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
1 Reply
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