Forum Discussion

Raul's avatar
Raul
Post Patron
6 years ago
Solved

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
Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago

    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.

2 Replies

  • AnkitBI's avatar
    AnkitBI
    Solution Sage
    6 years ago

    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.