Forum Discussion
filter row as SQL statement like %
I need help to filter rows. It needs to be made in edit query, NOT in DAX: i need to filter a row if "gbl" is included in a string like the SQL LIKE %gbl% example if the row is like x-s...
You can create a new custom column with Text.Contains([Column], "gbl") and filter this column in the next step, so it only shows TRUE values.
https://docs.microsoft.com/de-de/powerquery-m/text-contains
Anonymous
you can use advanced filtering in visual settings
this is not in edit query, I'm wrong?
Just thought about, you can do it even easier in Edit Query. Click on the Filter Arrow next to the column name, select Text Filters -> Contains.
