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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Fredde13
New Member

Issues transforming US date & time to european date

Hi,

 

I am pretty new to using power query and i am struggling a bit with some data i am trying to transform.

Currently i am receiving some .csv files on a monthly basis where i have managed to transform most of the data to be as accurate as possible. However i am struggling with formatting the date and time from US to european layout.

 

Fredde13_0-1665596258970.png

 

When i try to transform this using locale to Swedish it changes it to 9th of january 2022. When in fact the date is 1st of september 2022. The time isn't really of importance.

 

What i would like in the long run is to from this create a new custom column with only the month displayed.

 

Hopefully someone out there has a solution to my question, thanks a lot.

1 ACCEPTED SOLUTION
Fredde13
New Member

@Stachu Thanks, but i've actually tried that, but that didn't really help me.

 

However I just figured out the solution and if i set my regional settings in the queue to English (US) then it could change the layout to the correct one and being able to collect month and year correctly.

View solution in original post

2 REPLIES 2
Fredde13
New Member

@Stachu Thanks, but i've actually tried that, but that didn't really help me.

 

However I just figured out the solution and if i set my regional settings in the queue to English (US) then it could change the layout to the correct one and being able to collect month and year correctly.

Stachu
Community Champion
Community Champion

Do the following:

1) right click on the column

2) click on Change Type

3) click on Using locale...

4) set type to Date and Locale to English (United States)



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors