Forum Discussion
Select.Rows function with multiple Text.Contains functions
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")))
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")))
2 Replies
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")))
Thank you, this worked!
