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.

ColumnNew Col

A

IT
AIT
BB
CC
DD
AIT
BB

2 Replies

  • 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])