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
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")

Forum Discussion

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

Related content

Convert Decimal Duration in HH:MM:SS format

Convert from decimal to duration (HH:MM:SS)

Calculate Duration in hh:mm:ss

Convert Duration (d.hh:mm:ss & hh:mm:ss) to Decimals (in hours)

Convert Time (hh:mm:ss) to Duration (hh:mm:ss)