Forum Discussion
IF and Search Function for finding if a specific value exists in two columns
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!
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
5 Replies
v-yulgu-msftMicrosoft Employee
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 GuPerfect! 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
