Forum Discussion

wrbirdjr's avatar
wrbirdjr
Frequent Visitor
5 years ago
Solved

does not contain is not working like expected

I am simply trying to exclude rows that have the word sample or Sample or SAMPLE, etc. in one of the coulmns. 
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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"))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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