Forum Discussion

kenwilsonii's avatar
kenwilsonii
Frequent Visitor
3 years ago
Solved

Duration Data type shows as decimal, need HH:MM:SS

I used the Duration.FromText to convert a "HH:MM:SS" format for a new columnt from a  text field to Duration data type. The Steps are bit odd though as using Duration.FromText does not automatically ...
Need Help
  • danextian's avatar
    danextian
    3 years ago

    Hi kenwilsonii ,

     

    That behavior is expected. Although might have been set as type duration in Power Query they are shown as number when loaded to the model and also when aggregated in a visual. As a workaround, create a measure then format that measure to HH:MM:SS. If that still doesn't work, you can use FORMAT to convert it to text - that would be FORMAT ([Measure], "HH:MM:SS")

danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

Hi kenwilsonii ,

 

That behavior is expected. Although might have been set as type duration in Power Query they are shown as number when loaded to the model and also when aggregated in a visual. As a workaround, create a measure then format that measure to HH:MM:SS. If that still doesn't work, you can use FORMAT to convert it to text - that would be FORMAT ([Measure], "HH:MM:SS")