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
The table below I Get it from Web --> https://www.theweathernetwork.com/ca/14-day-weather-trend/ontario/toronto
I cleaned the table and kept Day, Date, High Temperture, Low Temperture columns. Power Query is showing the date column is Text (ABC), when I tried to change to Date, I got error messages. Some date like
05/26
05/27
wont covert to date but date like
06/01
06/02
will covert to date no problem.
Now I am thinking that is because of my computer date format is dd/mm/yyyy.
How can I fix that without change my computer date format. Thank you very much.
The file can be found here:
https://drive.google.com/file/d/16xl7PA9X0RqH5TsGm2xQZ8RDqUw8eTsz/view?usp=sharing
Solved! Go to Solution.
Hi @lastnn30 ,
In Power Query, right click on the top of the column, select change type, and select using locale.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @lastnn30 ,
In Power Query, right click on the top of the column, select change type, and select using locale.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Got it. Thank you so much for the help. I appreciate it.
Hi @lastnn30 ,
You are very welcome!
Nathaniel
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |