Forum Discussion
Solved
Searching text for keywords, while excluding all negative phrases
Hi there, hoping some advice as a still-learning PBI and PQ user. I'm having trouble getting to where I need this to be. I have a dataset of tickets. I need to search a field that contains a lot ...
You will want to have separate reference tables for the positive and the negative phrases.
Then you can use Power Query or DAX to do the comparison. You would first need to remove the false positives from the original string and then compare the remaining string against the match phrases.
lbendlin
Super User
Super UserYou will want to have separate reference tables for the positive and the negative phrases.
Then you can use Power Query or DAX to do the comparison. You would first need to remove the false positives from the original string and then compare the remaining string against the match phrases.