Filter Text Field with Keywords

[Anonymous]

Hello,

first of all. Im really new to all this. I found this post which sounds like my problem but didnt really help me: Solved: Filter text field on containing at least one keywo... - Microsoft Power BI Community

I try to create a Topic Model out of some comments (from users).

For each Topic I create a certain keyword list.

Now I want to filter the comments with a topic key word table and get a new List with the comments which include at least one key word. But not a list with dublicates.

example: 

      

for this example, the new coloumn should only show 3 comments - although comment "6" includes 2 KeyWords

so this should be the outcome:

I try to merge them, but I didnt work, because the comments have multiple caracters. 

Thoughts?

[Fowmy · Accepted solution]

@Anonymous 

I attached the file for you to check how it was done.

[Anonymous]

Thank you very much. 🙂

One more question: Is there a way to upgrade your function that it doesnt only get the correct written words? For example If my filterword is "price"...that it also gets "Price" or "prices"?