cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Convert number to date Power Query

Hi Experts

 

How would you use Power Query to Convert a date number i.e. 2020517 into 17/05/2020 uk format using Power Query,. i do not want to use calculate column as a i have thousand or rows.. 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

I am not sure I understood your question correctly, but please kindly check the below link.

 

I am using US format date, but you will easily understand what I was doing.

I hope this helps.

 

https://www.dropbox.com/s/4njs21yoe360kbh/Presentation1.mp4?dl=0 

 

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos!!


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

I am not sure I understood your question correctly, but please kindly check the below link.

 

I am using US format date, but you will easily understand what I was doing.

I hope this helps.

 

https://www.dropbox.com/s/4njs21yoe360kbh/Presentation1.mp4?dl=0 

 

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos!!


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

StefanoGrimaldi
Super User
Super User

hey, 

if the change type to date format isnt making it right for that format them without adding a new column you wont be able to differente approach:

1) create a new column that separetes the date by characters position from left to right and merged them back in all in a new column them delete the original one in a new step

2) create a dimensional table for dates and create a key column with that same format date key and make a relantionship with thtat table to manage the date via the dimensional table. 

 

if this helped give some kudos, if this solves your question please mark as solution for others to find it.





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors