Forum Discussion

keboon's avatar
keboon
Icon for Microsoft Employee rankMicrosoft 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 Keyword Column then the output will be "Keyword Found".   Any help would be appreciated.

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")

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    You can use below formula

    Result = IF(ISNUMBER(SEARCH('Table'[Keyword],'Table'[Search Query],,BLANK())),"Keyword Found")
  • keboon's avatar
    keboon
    Icon for Microsoft Employee rankMicrosoft 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.