Forum Discussion

CharlotteCity12's avatar
CharlotteCity12
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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? 

Need Help

2 Replies

  • olgad's avatar
    olgad
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi, right click on Duration, Transform, time only

     

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    2 years ago

    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