Filter if contains

Hi kassymov_su ,

Since columns Progress and ID are of different datatype and you have used in the same M query code line, you are receiving that error.

Bifurcating it into 2 different steps should resolve this:

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Progress] <> 1)),//For Progress NOT EQUALS 1
    #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each not Text.Contains([ID], "A")) // FOR ID NOT CONTAINS "A"

 PFA .pbix with solution. You can go to advanced editor and check.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn