FILTER WITH IF AND CONTAINSSTRING

[rafa97cteep]

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", "ninho".... would there be any way to use an IF with the CONTAINSSTRING to create a default filter to use the data segmentation

[Nathaniel_C · Accepted solution]

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]

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]

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