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 err...
DAX
if
if condition
  • az38's avatar
    az38
    6 years ago

    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

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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
6 years ago

az38 Thank you so much!!