filter row as SQL statement like %

[Anonymous]

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-scope/house-bill-of-lading-copy-pdf-custom;gon_aaagblse; customFormOID=77d3a26a-ce9c-4b95-9780-b0a36fb4059a

need to be keepd and filter since inclute gbl -> aagblse

all post I found was in DAX 

[Mariusz]

Hi @Anonymous 

Please follow the steps in the video below.

[video]

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

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]

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. 

[az38]

@Anonymous 

you can use advanced filtering in visual settings

[Anonymous]

this is not in edit query, I'm wrong?