topic Re: Search In Different Order in DAX Commands and Tips

Search In Different Order

LaurindaS — Wed, 18 Aug 2021 09:06:38 GMT

I'm looking to have a search field that looks in a table where it searches the same words, but the words could be in a different order. In excel, it would be similar to the contains and contains filter instead of the exact filter.

Example

Description Field: Pen Blue Medium Bic

In the search field if "blue pen" is entered I would like for this description to come up. It's only coming up if I type the words in the exact same order. Eg. "Pen blue", "blue medium" & "medium bic"

Thanks in advance for your help! 🙂

Laurinda

Re: Search In Different Order

goncalogeraldes — Wed, 18 Aug 2021 09:29:48 GMT

PBI has a functionality called "Synonyms" that may help you in this case! Please check the below link as it may provide some insights onto your problem:

https://www.biinsight.com/power-bi-synonyms-take-qa-experience-to-the-next-level/

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

Re: Search In Different Order

LaurindaS — Wed, 18 Aug 2021 11:21:18 GMT

Hi Goncalo,

This is our "work around" solution we have right now, but it's quite time consuming & leaves room for human error if I forget to add a variation,. There are thousands of fields in this table & some of the fields have alot of words in the description so I would have to put every variation that they might search to have it come up.

Example:

Description: Pen Blue Medium Point Bic Round Ballpoint

I would have to put every variation that they could potentially search.
Eg. Blue Pen

Medium Blue

Bic Pen

Bic Ballpoint

Ect.

I was hoping to find a way to have it search for all words in any order somehow in the programming so it doesn't allow for human error & more efficient.