does not contain is not working like expected

[wrbirdjr]

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

[Vera_33 · Accepted solution]

Hi @wrbirdjr 

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