Forum Discussion
CharlotteCity12
Microsoft Employee
Microsoft EmployeeDuration 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...
ppm1
Solution Sage
Solution SageIf 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