Forum Discussion

Jeffrey2's avatar
Jeffrey2
Icon for Helper I rankHelper I
4 years ago
Solved

"Does Not Contain" is picking up null values

I have a power query table that I have narrowed down to two records, one the original and one that is close to being a duplicate (the Comments column).   In record one, the Comments field is null. ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Jeffrey2 ,

     

    Try this instead:

    Table.SelectRows(#"Filtered Rows1", each not Text.Contains([Comments], "Duplicate") or [Comments] = null)

     

    Pete

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Jeffrey2 ,

 

Can you try to exclude the null on your filter like below?

Table.SelectRows(#"Filtered Rows1", each not Text.Contains([Comments], "Duplicate") and [Comments] <> null)

 

Hope this helps.