filter row as SQL statement like %

[snifer]

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 @snifer 

Please follow the steps in the video below.

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]

@snifer 

you can use advanced filtering in visual settings

[snifer]

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