IF and Search Function for finding if a specific value exists in two columns

[adamsumm]

Hello,

Very new to Power Bi so I am still trying to figure out how to complete some of the basics.  I am attempting to create a new comlumn that will print either "Personal" or "Company" when searching the Description column and the Transfered_to.cmdb_ci.  I want the function to print Personal if it finds the keyword personal in either column.  

The function below is what I am using but it appears to not be working.  It will only Print Personal if it finds the keyword in teh Description column but not in the other.  

personal = IF(
IFERROR(
SEARCH("personal", new_call[description]) || search("personal", new_call[transferred_to.cmdb_ci])
, -1) > -1,
"Personal",
"Company"
)

Thank you very much!

[v-yulgu-msft · Accepted solution]

Hi @adamsumm,

Please try this formula:

personal =
IF (
    SEARCH ( "personal", new_call[description],, 0 ) > 0
        || SEARCH ( "personal", new_call[Transfered_to.cmdb_ci],, 0 ) > 0,
    "Personal",
    "Company"
)

Regards,
Yuliana Gu

[adamsumm]

Perfect! thank you very much for helping out with this.  I am confused about this section of the code "

,, 0 ) > 0"

 I would love to learn so If your able to explain that would be great @v-yulgu-msft

Thank you!!!!

[v-yulgu-msft]

Hi @adamsumm,

Here is a document introducing the usage of SEARCH function for your reference: SEARCH Function (DAX). It explains each part inside this function.

Regards,
Yuliana Gu

[adamsumm]

Thank you! that site will help me out a lot!  

[v-yulgu-msft]

Hi @adamsumm,

Would you please kindly mark the corresponding reply as an answer so that it can benefit more community members?

Regards,
Yuliana Gu