Forum Discussion
rsbin
Community Champion
Community ChampionText Does Not Contain
Good Afternoon,
Haven't had to use Power Query in a while, but don't understand why I am unable to filter my column [Facility] correctly.
I want to include only those rows where the text "TSI" or...
bracked missing after each. Since you are using one and condition, hence brackets are needed.
Use this
= Table.SelectRows(#"Renamed Columns", each (not Text.Contains([Facility],"HUB") and not Text.Contains([Facility],"TSI")))Alternatively, you can use an OR condition with not outside'
= Table.SelectRows(#"Renamed Columns", each not (Text.Contains([Facility],"HUB") or Text.Contains([Facility],"TSI")))
A potentially easier way to exclude values from a row would be to use the M 'does not equal' operator ('<>'). I'd suggest something like this:
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Facility] <> "TSI" and [Facility] <> "HUB"
in
#"Filtered Rows"