topic Re: Replace one variable in a multible variables column while keeping the rest variable the same in DAX Commands and Tips

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

khaledSA — Thu, 14 May 2020 15:06:41 GMT

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

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

camargos88 — Thu, 14 May 2020 15:14:42 GMT

Hi khaledSA ,

Try this one:

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

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

khaledSA — Thu, 14 May 2020 15:52:10 GMT

Thank you Ricardo, worked perfect..