Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@Anonymous
I attached the file for you to check how it was done.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
I attached the file for you to check how it was done.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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"?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |