Forum Discussion
How to replicate a Excel text-to-column date conversion
there's a simpler way to do it via the PQ GUI:
right-click the column and then go Change Type => Using Locale...
then in the Dialog box select Date for Data Type and English (United States) for Localethis should do the trick :)
maracles look at my last response with the 4 pictures here
http://community.powerbi.com/t5/Desktop/How-to-change-the-date-format/m-p/40462#M15202
Hi Sean thanks for this, I had thought about doing it this way just figured there might be a simpler way! I'll use this method for now until they improve the basic functionality. Much appreciated.
there's a simpler way to do it via the PQ GUI:
right-click the column and then go Change Type => Using Locale...
then in the Dialog box select Date for Data Type and English (United States) for Localethis should do the trick :)
radpir Thank you for this, from your answer I managed to find a solution. I actually had to add a step which was to convert my column to text format first, and then use Change Type > Using Locale but after that it worked perfectly.
Greg_Deckler Thank you for your suggestion, that would also have worked however radpir solution allows me to do it earlier in the ETL process.
Thank you both.
