Powerquery filtering table data using OR for two columns

[Anonymous]

Hi Team 

Good Day !

Is there any way to filter a table using two columns with OR condition like if (state = "true" OR  status="completed") in Power query Actual Power Query = Table.SelectRows(#"Removed Other Columns", each ([InstallStatus] = "Completed" OR [AppointmentStatus] = "Install Completed"))

Thanks in advance !

[HotChilli · Accepted solution]

lower case 'or'

[Anonymous]

Thank you