It would be super useful to be able to create a conditional column in power query using a search function that contains wildcards.
Example:
I want to sort complaints about coffee. Some people write the coffee is really bad, others write the coffee is bad, others write the coffee is good. I would like to be able to search "Coffee*bad" to create a conditional column based solely off of people who say coffee and bad, but not the people who say coffee * good.
It has many uses and of course can be done with RegEx in VBA, but sometimes its completely impractical if using powerbi and need refreshing reports without running VB scripts.