Is it possible to do a search for a set of words without order in a column?

[joaohenrique300]

I want to do it as if it were a search in a database, through the words contained in each “cell” of the column. The purpose is to refer to a lessons learned or risk log.
There are some visuals that do this, but they need the words to be in order, for example:

"We have a problem with IT"

If I search for "problem with IT" it returns the cell as true and I can query.
But if I put "problem IT" it returns null, without query.

[PhilipTreacy · Accepted solution]

Hi @joaohenrique300 

Yes you can do this in Power Query as described here

Searching for text strings in Power Query 

Apologies for not rewriting all of that but it's quite an involved process to explain.

Regards

Phil