filter row as SQL statement like %

Question

I need help to filter rows.&nbsp;It needs to be made in edit query, NOT in DAX:&nbsp;i need to filter a row if&nbsp;"gbl" is included in a stringlike the SQL LIKE&nbsp;%gbl%&nbsp;example if the row is likex-scope/house-bill-of-lading-copy-pdf-custom;gon_aaagblse; customFormOID=77d3a26a-ce9c-4b95-9780-b0a36fb4059aneed to be keepd and filter since inclute gbl -&gt; aagblse&nbsp;all post I found was in DAX&nbsp;&nbsp;

anonymous · Answer

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

az38 · Answer

Anonymous&nbsp;
you can use advanced filtering in visual settings

anonymous · Answer

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

mariusz · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Please follow the steps in the video below.

Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me. LinkedIn 
&nbsp;

anonymous · Answer

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 -&gt; Contains.&nbsp;&nbsp;&nbsp;

Forum Discussion

filter row as SQL statement like %

5 Replies

Related content

IF Statement with Filter

OR Statement ?

SQL Statement opcion error

Return Filter from Switch Statement DAX

SUMX with Filter or If Statement