Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

 

 

  • 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

2 Replies

  • az38's avatar
    az38
    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      az38 Thank you so much!!