cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Route217 Member
Member

Change date type in Power Query using M Script

Hi Experts

 

How could you change the date type format from US to UK current i have 3/15/2019, i would like to show the date as 15/3/2019. 

using M script step.

let
blah blah
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ISSUE_OCCURRENCE_DT", type date}})
in
    #"Changed Type"
1 ACCEPTED SOLUTION

Accepted Solutions
Icey New Contributor
New Contributor

Re: Change date type in Power Query using M Script

Hi @Route217 ,

1. The date format display decided by the local client Regional settings. Please make sure your region setting like below. Then you don't need to change the date format and it will be "dd/MM/yyyy".

date.PNG

2. If you don't want to change the Region settings. You can refer to this video: Changing Date Format (MM/DD/YYYY to DD/MM/YYYY).

 

Best Regards,
Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Icey New Contributor
New Contributor

Re: Change date type in Power Query using M Script

Hi @Route217 ,

1. The date format display decided by the local client Regional settings. Please make sure your region setting like below. Then you don't need to change the date format and it will be "dd/MM/yyyy".

date.PNG

2. If you don't want to change the Region settings. You can refer to this video: Changing Date Format (MM/DD/YYYY to DD/MM/YYYY).

 

Best Regards,
Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 272 members 2,613 guests
Please welcome our newest community members: