Text Contains function to search multiple text from same field

[ashpbi]

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

[Ashish_Mathur]

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]

Not sure what is wrong, getting an error message