Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
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 of text. The goal is to identify possible tickets with desired keywords, like the word "complaint."
Additionally, I have a list of negative keywords/phrases, to exclude false positives. For example, part of the template in many tickets include the phrase "If a complaint was filed," I need to exclude that from my results of possible tickets, if no other keywords were found.
How can I search for at least one of my desired keywords, while excluding all negative phrases?
The data doesn't need to look like this, but this is what I'm trying to achieve in sorts:
Ticket ID | Text To Search | Text Contains | Phrases To Exclude | Possible Ticket |
1 | I have a serious complaint | complaint | If a complaint was filed; made | TRUE |
2 | If a complaint was filed | complaint | If a complaint was filed; made | FALSE |
3 | I am so mad | mad | If a complaint was filed; made | TRUE |
4 | I have made a request | mad | If a complaint was filed; made | FALSE |
5 | I have made a complaint to your boss | complaint; mad | If a complaint was filed; made | TRUE |
Solved! Go to Solution.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
18 | |
10 | |
9 | |
9 | |
8 |
User | Count |
---|---|
16 | |
15 | |
13 | |
12 | |
11 |