Forum Discussion

khaledSA's avatar
khaledSA
Frequent Visitor
6 years ago
Solved

Replace one variable in a multible variables column while keeping the rest variable the same

I have a column with multiple A,B,C,D values. I would like to create a new column that will replace A to IT and keep the other values the same, example below. Thank you. Column New Col A I...
  • camargos88's avatar
    camargos88
    6 years ago

    Hi khaledSA ,

     

    Try this one:

     

    NewColumn = IF(TABLE[COLUMN] = "A"; "IT"; TABLE[COLUMN])

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

Hi khaledSA ,

 

Try this one:

 

NewColumn = IF(TABLE[COLUMN] = "A"; "IT"; TABLE[COLUMN])

  • khaledSA's avatar
    khaledSA
    Frequent Visitor
    6 years ago

    Thank you Ricardo, worked perfect..