Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |