Forum Discussion
Converting abbreviated Month(Text) to Month(Date Data type) Format
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.
When I do this there is an error-
Failed to save modifications to server. A circular dependency was detected.
Community ChampionAnonymous 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.