Forum Discussion

tmacfrank's avatar
tmacfrank
Frequent Visitor
8 years ago
Solved

Replace mutilple values in a column

Hi,   I want all that contian "Deposit" in column [type] become "Deposit" in a new column. Others remain the same. Any hint for DAX ?    type                             new type   Deposits-bl...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    tmacfrank try using the search function

     

    newtype = IF(SEARCH("Deposit",table1[type],1,0),"Deposit",table1[type])

Anonymous's avatar
Anonymous
Not applicable
8 years ago

tmacfrank umm try like a normal or

 

IF(OR(SEARCH("Deposit",col1,1,0),SEARCH("Dep",col1,1,0),"Depost", col1)

tmacfrank's avatar
tmacfrank
Frequent Visitor
8 years ago

it say too many arguments were passed to the OR function.