Forum Discussion
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", "ninho".... would there be any way to use an IF with the CONTAINSSTRING to create a default filter to use the data segmentation
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
3 Replies
- Nathaniel_C
Community Champion
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.
NathanielNice 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
