Forum Discussion
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...
tmacfrank try using the search function
newtype = IF(SEARCH("Deposit",table1[type],1,0),"Deposit",table1[type])
tmacfrank try using the search function
newtype = IF(SEARCH("Deposit",table1[type],1,0),"Deposit",table1[type])
Works perfectly, Thanks a lot.
However, I cannot search two or more values at one time, don't I.
for example
newtype = IF(SEARCH("Deposit" or "Dep",table1[type],1,0),"Deposit",table1[type]), do i need one more if for searching "Dep". Thanks
