Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter Text Field with Keywords

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?

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      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"