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)
But of course this only checks the features, not the keywords. if anyone knows how to modify so it goes through the keywords instead and returns the feature, it would be appreciated.
