Forum Discussion

keboon's avatar
keboon
Microsoft Employee
4 years ago
Solved

Power Bi Formula for (Cell contains multiple formulas in Excel)

Hi All:   I am trying in to write a formula so that the formula 1st looks at the Keyword Column, see the keyword then searches the Search Query Column and if it contains keywords found in the Keywo...
Need Help
Tips and Tricks
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    You can use below formula

    Result = IF(ISNUMBER(SEARCH('Table'[Keyword],'Table'[Search Query],,BLANK())),"Keyword Found")
keboon's avatar
keboon
Microsoft Employee
4 years ago

I have one more question that is relevent to the revious answer.

Suppose the words in the search query match the keywords but the words are in a different order and have extra words in it.  Is there a formula that can find the different order of words and still count as a keyword found for the results?  Screenshot below of the problem.