Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

IF and Search formula for multiple values

Hi,

 

I want to search with IF and SEARCH to create a single value from multiple values.  

 

My problem is that it works when I only search one value, but if I search multiple values I get an error :  "Too few arguments were passed to the IF function. The minimum argument count for the function is 2."

 

#Searching 1 value at a time (working)

Newcolumn = if(search("name1", 'databasename'[Table], 1, 0 ) > 0, "Newname1", 'databasename'[Table])

 

#Searching 2 values at a time (not working)

Newcolumn = if(search("name1", 'databasename'[Table], 1, 0 ) > 0, "Newname1", 'databasename'[Table]), if(search("name2", 'databasename'[Table], 1, 0 ) > 0, "Newname2", 'databasename'[Table])

 

 

Anyone a solution?

 

Regards,

 

Poweringbi

 

 

1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

Hi @Anonymous 

its completely wrong statement

try

Newcolumn = if(search("name1", 'databasename'[Table], 1, 0 ) > 0, "Newname1", if(search("name2", 'databasename'[Table], 1, 0 ) > 0, "Newname2", 'databasename'[Table]))

do not hesitate to give a kudo to useful posts and mark solutions as solution


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

2 REPLIES 2
az38
Community Champion
Community Champion

Hi @Anonymous 

its completely wrong statement

try

Newcolumn = if(search("name1", 'databasename'[Table], 1, 0 ) > 0, "Newname1", if(search("name2", 'databasename'[Table], 1, 0 ) > 0, "Newname2", 'databasename'[Table]))

do not hesitate to give a kudo to useful posts and mark solutions as solution


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

@az38 Thank you so much!! 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.