Forum Discussion
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 "...
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.
Not sure what is wrong, getting an error message