Forum Discussion

ask's avatar
ask
Helper III
9 years ago

Numbers convert into duration

I have number type column, i want to convert those numbers into duration format : 00:00:00. How to do that ? Thanks
Need Help
dkay84_PowerBI's avatar
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?

ask's avatar
ask
Helper III
9 years ago

dkay84_PowerBI

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

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee
    9 years ago

    So is that seconds, minutes, days, etc.?

    • ask's avatar
      ask
      Helper III
      9 years ago

      dkay84_PowerBI

       

      It looks like. But I don't think that is right.

      • dkay84_PowerBI's avatar
        dkay84_PowerBI
        Microsoft Employee
        9 years ago

        What is the value before you changed the data type to duration?