Forum Discussion

rafa97cteep's avatar
rafa97cteep
Frequent Visitor
4 years ago
Solved

FILTER WITH IF AND CONTAINSSTRING

Hi guys,   i trying create a filter using a word/string contained in the analyzed cell, as in the image below:   For example, cells have several descriptions, such as "sanar", "defeito", "n...
  • Nathaniel_C's avatar
    Nathaniel_C
    4 years ago

    Hi rafa97cteep ,
    Sure, go to Power Query, go to add Column, Conditional column and see my pic below.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

     

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

Hi rafa97cteep ,
Sure, go to Power Query, go to add Column, Conditional column and see my pic below.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 

 

  • rafa97cteep's avatar
    rafa97cteep
    Frequent Visitor
    4 years ago

    Nice Nathaniel_C  😁 its work for me!!!!

     

    Last question, this condition can distinguish if the same word is spelled differently? for example: house House hoUse

     

    Because I wanted to ensure that this condition caught the word, regardless of how it is written

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Hi rafa97cteep ,

      Good point.  Add a column that uses Text.Lower() -see picture- and point the previous column to that new column. This way no matter how they type it, it gets converted to lower case for the test.
      Once again, please mark this as solved, so that other people who are looking for a solution can find it easier!


      Thank you, and good luck!


      Nathaniel