Remove rows based on two Columns

[joshua1990]

Hi all!

I have a table with this structure:

Order Nr	Date	Step	Value
1001	01.01.2022	10	5
8001	01.01.2022	10	5
2001	01.01.2022	11	5
1002	01.01.2022	10	6

Now I would like to filter out all rows where

1. Order Nr starts with 8
2. Order NR starts with 5 and where Step = 11 or 12

Since this is a really huge table I have a strong focus on the performance.

What would be your sugestion here?

[PowerBIOrg · Accepted solution]

Hi, 

With the following data:

I filter with the following query and get the below output

not Text.StartsWith([Order Nr], "8") and not (Text.StartsWith([Order Nr], "5") and [Step] >= 11 and [Step] <= 12 )

Regards.