Forum Discussion

kvitnitskiy's avatar
kvitnitskiy
Frequent Visitor
3 years ago
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...
Convert
time
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.