Forum Discussion
Solved
Remove rows based on two Columns
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
- Order Nr starts with 8
- 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?
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.
1 Reply
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.