Forum Discussion
Dealing with dates containing ordinal indicators in Power Query
I have a table which contains millions of rows - basically for each date since 2011, each product in my company, and each customer we have, there is an attribute. The data source (analysis servic...
When you were replacing the "th","st" how did you get it to not pull from the month?
Example:
August 25th 2019 --> Augu 25 2019
- Find and replace Augu with August afterwards.
