Conditional Column

[sfcmartint1985]

Hi everyone,

Our team is working with Power BI to analyze unstructured data (hot line complaints) and in an effor to trend the data we are using a conditional column to search for key terms within each complaint in an effort to categorize the complaint. Example: Key terms, community, care, town, doctor all result in a conditional column result of 'Community'.  Mostly it works great but is there a way to add multiple key words to the search value?  We have tried separating with a comma, space, etc, but do not get the correct results. Below is a snip of me trying to add mulitple terms which fails. 

[mukeshkasi25]

Hi @sfcmartint1985  ,

Here is the screenshot of my workings;
Here I am going to an custom column based on country,
for eg, if the country is UK,Belgium then Europe and
if the country is Spain,Netherlands then WesternEurope

Go to PowerQuery->Add Column(task basr)->CutomColumn

Use this in the custom query formula:
= if List.ContainsAny({[Country]},{"UK","Belgium"}) then "Europe" else

if List.ContainsAny({[Country]}, {"Spain", "Netherlands"}) then "WesterernEurope" else "Other")

Here is the result:

[Vijay_A_Verma]

Insert a conditional column and put following formula

Change Text to your column name

"a", "b"....to your list of values which you are trying to find

if List.ContainsAny({[Text]}, {"a", "b"}, (x,y)=>Text.Contains(x,y)) then "TomTest" else null