How to pass two conditions in query editor?

[Anonymous]

Hello, I have a data set like this with 65 million rows. I want to filter the data based on two conditions. I used to filter the data with only one condition like this

#"Filtered Rows" = Table.SelectRows(#"Columns ETL", each ([cfname] = "Data Request Environment"))

But I want to add another condition addational to "each ([cfname] = "Data Request Environment"" which will be something like this 

or [cfname] = “Impacted Project””

How can I apply this two conditions to one dataset in query editor? 

[VahidDM · Accepted solution]

Hi @Anonymous 

Try this:

#"Filtered Rows" = Table.SelectRows(#"Columns ETL", each [cfname] = "Data Request Environment" or [cfname] = "Impacted Project")

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/