Forum Discussion
Converting abbreviated Month(Text) to Month(Date Data type) Format
Hi, I have Month column which of text data type having Month in the format of Jan, Feb, Mar, Apr.... I want to convert to format like January, February in Month format. Because I'm sorting, it is...
Anonymous Yeah, I was afraid of a circular dependency which I why I didn't suggest that approach. You likely need to do that in Power Query Editor with nested if then else statements since Power Query does not have a switch statement. Another way is to duplicate the column and then do a bunch (12) replace steps.
Please add a new column in the query editor of the transform data.
Then select the month column and click Sort by column.
V-lianl-msft
Community Support
Community SupportPlease add a new column in the query editor of the transform data.
Then select the month column and click Sort by column.
I received a column of null.