Table filtering options - delete rows with specific text

Hi Anonymous ,

You can deal with it in Power Query Editor:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSjYwVNJRSsksSk0uATIMlWJ1QIJGQHZqbmJmDpKYMZBdkJiZolCcmliUnIEkY4JshBFU0BTJCJiYGYYRMBlzZCOMoYIWSEbAxCwxjADKxAIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [customer = _t, #"combinations of channels" = _t, campaigns = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"customer", type text}, {"combinations of channels", type text}, {"campaigns", Int64.Type}}),
    #"FilteredRows" = Table.SelectRows(#"Changed Type", each not(Text.Contains([combinations of channels], "paid search") and [campaigns] = 3))
in
    #"FilteredRows"

In addition, you can refer the solution in the following links to get it.

"Does Not Contain" text filter filters too much

Power Query Filter Rows by NOT Contains Criteria - Single Formula Solution

Select Rows if text Contains (Value of a list)

Best Regards