Forum Discussion
Solved
Convert text value to long time
Hello comunity. I have duration value in sec(integer), I use DAX to convert it to time Movement Time = VAR Duration ='Summary table'[Duration(sec)] VAR Hours =INT ( Duration / 3600) VAR Mi...
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
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kvitnitskiy , You can have a number like
1*time(h,m,s)
That will be a fraction of a day . you can multiply with 24 to get hours
24*60 to get minutes