Forum Discussion

theapengelly's avatar
theapengelly
Frequent Visitor
2 years ago
Solved

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 st...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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")))

amitchandak's avatar
amitchandak
Super User
2 years ago

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's avatar
theapengelly
Frequent Visitor
2 years ago

Thank you, this worked!