Forum Discussion
Duration Field coming in as date/time
I have these fields in my EXCEL sheet:
Duration
0:58:01
1:25:32
0:00:59
When I bring it into PowerQuery it formats it as:
How do I force PowerQuery to bring in this field as just the text?
2 Replies
Hi, right click on Duration, Transform, time only
If you convert them to text, they will sort alphabetically and you won't be able to do analysis easily (min, max, avg time). A good practice is to bring them in as time or duration, do your analysis, and then FORMAT it how you like in the measure/visual.
Calculate and Format Durations in DAX – Hoosier BI
Pat
