I have duration value in sec(integer), I use DAX to convert it to time
Then I try appy time format for this column and got error
So this perfectly works untill my time value less or equall to 23:59:59.
question - how can I convert duration to time like hhh:nn:mm and apply time format as well
Go to Solution.
Hi @kvitnitskiy ,
Power BI doesn't support Duration data type for time over 24 hours.
If you need the time format, you can consider adding an extra column to save the part beyond 24h, or use the Date\Time format to convert the part beyond 24h to days
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Please see this article for a better way to handle durations like this.
Calculate and Format Durations in DAX – Hoosier BI
@kvitnitskiy , You can have a number like
That will be a fraction of a day . you can multiply with 24 to get hours
24*60 to get minutes
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.