Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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..
Solved! Go to Solution.
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 accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |