Forum Discussion

ashpbi's avatar
ashpbi
Regular Visitor
7 years ago

Text Contains function to search multiple text from same field

Hi Champ's

 

I am new to PBI, wondering if someone can help me with below query,

 

i have a note field with general text, and i want to create a new column with 

 

if note field contains both "enquiry" and "OBG" then "A"

if note field contains "enquiry" NOT "OBG" then "B"

else "C"

 

whats the best way to do this?

 

Ash

Need Help

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    Try this calculated column formula

     

    =IF(SEARCH("Enquiry",Data[Note],-1)>0,IF(SEARCH("OBG",Data[Note],-1)>0,"A","B"),"C")

     

    Hope this helps.

    • ashpbi's avatar
      ashpbi
      Regular Visitor
      7 years ago

       

      Not sure what is wrong, getting an error message