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