Power Query offers a few ways to filter by multiple conditions, allowing for both AND and OR logic. Here are two common methods:

1. Using Table.SelectRows with Lambda function (AND logic):

This method leverages a Lambda function to define your filtering criteria. It ensures all conditions must be met for a row to be included.

* Steps:
1. Select the table you want to filter.
2. Go to "Transform" -> "Advanced" -> "Filter Rows".
3. In the formula bar, enter a formula like this:

```
Table.SelectRows(#"YourTableName", each [Column1] = Value1 && [Column2] > Value2 && [Column3] <> Value3)
```

- Replace `#"YourTableName"` with your actual table name.
- Replace `Column1`, `Column2`, `Column3`, `Value1`, `Value2`, and `Value3` with your specific column names and filter values.

* Explanation:
- The `Table.SelectRows` function takes a table and a filter function as arguments.
- The Lambda function (`each`) defines the filtering criteria.
- The `&&` operator represents the AND logic, ensuring all conditions must be true.

2. Using Filter with multiple conditions (OR logic):

This method uses the `Filter` function and allows filtering based on meeting any of the specified criteria.

* Steps:
1. Select the table you want to filter.
2. In the formula bar, enter a formula like this:

```
= Table.Filter(#"YourTableName", List.AnyTrue({
[Column1] = Value1,
[Column2] > Value2,
[Column3] <> Value3
}))
```

- Replace the placeholders as mentioned previously.

* Explanation:
- The `Table.Filter` function takes a table and a filtering expression.
- `List.AnyTrue` checks if any condition in the list evaluates to true.
- This allows rows to be included if they meet at least one of the specified criteria (OR logic).

Choosing the Right Method:

- Use the first method (AND logic) if you want to filter for rows that meet all your specified conditions.
- Use the second method (OR logic) if you want to filter for rows that meet any of your specified conditions.

Remember to adjust the formulas based on your specific column names and desired filtering values. You can also expand these examples to include even more conditions for complex filtering in Power Query.