Solved: does not contain is not working like expected

wrbirdjr · ‎02-23-2021

I am simply trying to exclude rows that have the word sample or Sample or SAMPLE, etc. in one of the coulmns.

Vera_33 · ‎02-23-2021

Change the "Or" in the Filter Rows to "And", it will work. And it is M, not DAX. Alternatively, you can modify the M code like this

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each not Text.Contains( Text.Lower([Product Name]), "sample"))

Vera_33 · ‎02-23-2021

Change the "Or" in the Filter Rows to "And", it will work. And it is M, not DAX. Alternatively, you can modify the M code like this

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each not Text.Contains( Text.Lower([Product Name]), "sample"))

does not contain is not working like expected