Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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
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!!!!
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
Thank you! that site will help me out a lot!
Hi @adamsumm,
Would you please kindly mark the corresponding reply as an answer so that it can benefit more community members?
Regards,
Yuliana Gu
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |