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, i...
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.

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.

Raul's avatar
Raul
Post Patron
6 years ago

Thanks AnkitBI for your good answer!