Easily Fix Dates Formatted as Text with Power Query - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Christian
Thanks for the lesson - learned a lot.
I have a Question about the Import.
My csv Data shows the Date like 02.01.2021 (EU 02.Jan, 2021) when i load in my files to Power Query it shows me a text 2012021 - other Dates like 30.01.2021 will show up as 30012021 (1 more Number)
With both i have wrong data with Dates in future or an -Error- is showing up - is there any fix to that Problem? - or is there a way to tell power query that he just have to import the data without removing something like the Dots or the Zerro in front?
Thanks a lot
reply
Thanks for the lesson - learned a lot.
I have a Question about the Import.
My csv Data shows the Date like 02.01.2021 (EU 02.Jan, 2021) when i load in my files to Power Query it shows me a text 2012021 - other Dates like 30.01.2021 will show up as 30012021 (1 more Number)
With both i have wrong data with Dates in future or an -Error- is showing up - is there any fix to that Problem? - or is there a way to tell power query that he just have to import the data without removing something like the Dots or the Zerro in front?
Thanks a lot
reply
Peace
This was so beautiful because I was stuck in trying to change January to Jan and February to Feb but when you said it is done in excel and not in Power Query. I thought OMG now I know why I got stuck. Didn't know that you can't change full month names to shorter names in PQ. Why did you put 0,2,4 for Positions? This is confusing. In my example, some are 11/29/2019 and some are 1/7/2018 so what would be positioned for these examples? Thanks
reply
This was so beautiful because I was stuck in trying to change January to Jan and February to Feb but when you said it is done in excel and not in Power Query. I thought OMG now I know why I got stuck. Didn't know that you can't change full month names to shorter names in PQ. Why did you put 0,2,4 for Positions? This is confusing. In my example, some are 11/29/2019 and some are 1/7/2018 so what would be positioned for these examples? Thanks
reply
Emre
Hi Lynda,-
What I want to learn is that since there are Microsoft engineers who developed the DAX software language and have a much broader formula and data analysis power with the use of DAX, why do the formulas we use in excel have such limited capacity?-
More precisely, when there was a powerful analysis program like Excel, why was the need to develop a program like PowerQuery and use a different software language?
Thank you
reply
Hi Lynda,-
What I want to learn is that since there are Microsoft engineers who developed the DAX software language and have a much broader formula and data analysis power with the use of DAX, why do the formulas we use in excel have such limited capacity?-
More precisely, when there was a powerful analysis program like Excel, why was the need to develop a program like PowerQuery and use a different software language?
Thank you
reply
Seamus
Thanks Mynda that's very helpful. I have file coming to me from Project Managers all over the world and so from mutiple locales. They are all text fields. Is there a way to process data from multiple locales into the format in my locale. Concretely, I have text fields from UK in 01122020 format and12012020 format. Thanks
reply
Thanks Mynda that's very helpful. I have file coming to me from Project Managers all over the world and so from mutiple locales. They are all text fields. Is there a way to process data from multiple locales into the format in my locale. Concretely, I have text fields from UK in 01122020 format and12012020 format. Thanks
reply
Greegan
Mynda, I've come across dates where its shown as August 1st or July 2nd etc. I've been using Replace to remove st, nd, rd, and th from the dates and then a simple date format change is done, but I'm wondering if you have a simpler way of formatting this?
reply
Mynda, I've come across dates where its shown as August 1st or July 2nd etc. I've been using Replace to remove st, nd, rd, and th from the dates and then a simple date format change is done, but I'm wondering if you have a simpler way of formatting this?
reply
Patrick
Not accurate for 2010. (version I still had for free). No option for positions. I had to split columns multiple times using number of characters. There were other parts that did not work with all of the methods, some but not all
reply
Not accurate for 2010. (version I still had for free). No option for positions. I had to split columns multiple times using number of characters. There were other parts that did not work with all of the methods, some but not all
reply
Overdraft
Thank you so much Mynda! I've been struggling with the last form of date conversion every month for years now and never thought to try PQ... it works flawlessly!
reply
Thank you so much Mynda! I've been struggling with the last form of date conversion every month for years now and never thought to try PQ... it works flawlessly!
reply
Damilola
Stuck on the first example ma'am. It keeps returning -Error- for the merged column after trying to change the data type from number to date. I'm confused.
reply
Stuck on the first example ma'am. It keeps returning -Error- for the merged column after trying to change the data type from number to date. I'm confused.
reply
Dallman
Fantastic lesson and presentation. Thank you so much! (I can't imagine what the four trolls with the thumbs down as I write this were thinking!)
reply
Fantastic lesson and presentation. Thank you so much! (I can't imagine what the four trolls with the thumbs down as I write this were thinking!)
reply
George
I cannot believe the timeliness of this video! I had this exact problem this week. Great help. Thank you for the video instruction. So simple!
reply
I cannot believe the timeliness of this video! I had this exact problem this week. Great help. Thank you for the video instruction. So simple!
reply
Add a review, comment
Other channel videos
