Forum Discussion
Power Query - How to Format Date Column to Specific Format?
I have a bit of a quick question I was hoping for some help In Power Query I have a .csv that I have downloaded One of the columns is set as a "Text" data type when its clearly a date column ...
rodneyc8063_1 in your powerquery window, you can create a new column from your date column. You select the date column and then go to File->Column from example -> from selection
then in the custom column type first 2-3 values as above then power query automatically will convert values for you.
Thanks for this tip!
I was just curious and hoping for something as easy as the front end PBI desktop where I could simply "change" the format of the data column.
I thought the same or very similar functionality should exist in both PBI desktop and Power Query and was just confused why it wasnt easier to change the format of a date column in Power Query as its a pretty common thing that needs to be done.