Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Yacine-Eurovia
Frequent Visitor

I can't turn data type to duration

Hello everyone,

 

I'm currently trying to turn a string column to duration type using Power Query :

 

PBI1.png

 

But it results as an error :

 

PBI2.png

 

Why do you think that happens? Do you think it doesn't work because of the data format or something else ?

3 REPLIES 3
KBO
MVP

HI @Yacine-Eurovia ,

here is a the same question, maybe it solves the Problem 🙂 https://community.powerbi.com/t5/Power-Query/Duration-conversion-issues/td-p/819935

 

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Hello,

Thanks for the tip, it kinda worked, but not perfectly : PBI3.png

 

The format is all right, but it's now counting what are supposed to be hours as minutes.
I guess it's because of something in the DAX code. I'm not very found of this code, so does an easy fix exists ? Or maybe resources to learn more about the DAX.

Thank you by advance.

Hi @Yacine-Eurovia ,

this is not DAX its M-Script in Power Query :). If you are looking to learn more about Power Query, there are a lot of great Blogs and Youtube Videos out there :).

If you have a Demo file for me I can check your code and formatting 🙂

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.