cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Filter a tabla

Hello everyone,

I need to filter on the Power Query screen of the Power BI a table to show all the records whose field Field1 does not start with a value (607) and that Field2 is empty. That is, if the registration begins with 607 in its Field1 and its Field2 is equal to white, it should not be shown, all others should.
 
I have introduced this function but it does not return the expected result:
= Table.SelectRows(#"Type changed", each not Text.StartsWith([Field1], "607") and [Field2] = "")
 
What is wrong with the function?
Thank you
1 ACCEPTED SOLUTION
Solution Sage
Solution Sage

If I understand requirement correctly, try below

Table.SelectRows(#"Type changed", each not (Text.StartsWith([Field1], "607") and [Field2] = ""))

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.

View solution in original post

2 REPLIES 2
Solution Sage
Solution Sage

If I understand requirement correctly, try below

Table.SelectRows(#"Type changed", each not (Text.StartsWith([Field1], "607") and [Field2] = ""))

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.

View solution in original post

Thanks @AnkitBI for your good answer!

 

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

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.

Top Solution Authors
Top Kudoed Authors