This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Sorry, new to PBI and tried searching for help but couldn't find this exact problem.
I have Feedback, which is just a body of text StoreFeedback[text]
I then have a table with categories and keywords.
| Feature[features] | Feature[keywords] |
| Category 1 | red, blue, green |
| Category 2 | black, white |
| Category 3 | purple |
| Category 4 | dark orange, light gray, magenta |
I want to be able to create a new column and if one of the keywords are found in Feedback[body], return the category. If no keywords are found, just a simple no match works.
Currently I have :
Features Mentioned =
var _1 = maxx(filter(Features,
SEARCH(Features[Features], StoreFeedback[text],,0)>0),Features[Features])
return
if(isblank(_1), "No match",_1)
@COWA , Refer if one of the two can help
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE
Sorry, wasn't too clear in my original problem description I think. I updated.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 23 | |
| 23 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 63 | |
| 38 | |
| 25 | |
| 23 | |
| 22 |