Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
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
Hi, right click on Duration, Transform, time only
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
67 | |
61 | |
23 | |
17 | |
12 |