cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snifer
Post Patron
Post Patron

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

 

5 REPLIES 5
Mariusz
Super User II
Super User II

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

 

boca87
Helper I
Helper I

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

 

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
Super User II
Super User II

@snifer 

you can use advanced filtering in visual settings

Снимок.PNG


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.