Select.Rows function with multiple Text.Contains functions

[theapengelly]

Hi,

I am trying to write a Select.Rows function in PowerBI Desktop using the Text.Contains function, as I want it to filter out everything except values in the column that contain certain text strings. I am trying to use the OR statement but it is not recgonising it.

This is what I believe should work but is it not, please help!!

= Table.SelectRows(#"Grouped Rows", OR(each Text.Contains([name], "Salesperson"), each Text.Contains([name], "Price"), each Text.Contains([name], "Item"), each Text.Contains([name], "Date"), each Text.Contains([name],  "Status")))

[amitchandak · Accepted solution]

@theapengelly , Try like

= Table.SelectRows(#"Grouped Rows", (each Text.Contains([name], "Salesperson"), each Text.Contains([name], "Price") or Text.Contains([name], "Item") or Text.Contains([name], "Date") or Text.Contains([name], "Status")))

[theapengelly]

Thank you, this worked!