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

[khaledSA]

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	IT
A	IT
B	B
C	C
D	D
A	IT
B	B

[camargos88 · Accepted solution]

Hi @khaledSA ,

Try this one:

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

[khaledSA]

Thank you Ricardo, worked perfect..