I have number type column, i want to convert those numbers into duration format : 00:00:00. How to do that ? Thanks

My prediction is that you will get the time that corresponds with the fraction of your division: You reallly need to go back and find out what your value represents, otherwise you are bound to create the most beautiful dashboards with highly unreliable information and you'll be in big trouble sooner or later.

In query editor, select the column and the right click on the column and select change type. then you can select duration from there. It can also be completed on the ribbon. You have to do this in query editor.

kcantor I did. But it shows like : 4356.00:00:00 I don't think it is right.

What does 4356 represent? It looks like it is being evaluated as days. Also, how is it being calculated?

dkay84_PowerBI4356 is a number in that duration column. After apply for Duration from Change Data Type, it returns 4356,00:00:00

Numbers convert into duration | Microsoft Fabric Community

16 Replies

kcantor
Community Champion
9 years ago
In query editor, select the column and the right click on the column and select change type. then you can select duration from there. It can also be completed on the ribbon. You have to do this in query editor.
- ask
  Helper III
  9 years ago
  kcantor I did. But it shows like :
  4356.00:00:00
  
  I don't think it is right.
  - dkay84_PowerBI
    Microsoft Employee
    9 years ago
    What does 4356 represent? It looks like it is being evaluated as days. Also, how is it being calculated?

Forum Discussion

Numbers convert into duration

16 Replies

Related content

Converting whole number to duration

Convert Text Time Duration

Convert text to number

Convert Text Duration to Type Duration

Convert Number to Date