Issue with Costum Column with if condition

[DONB87]

Hii Community

I'm struggling with a if condition in the costum Column. 

I have two colums column1 there i have values and null values, and i have column 2. The goal is to repleace all not null values from column 1 to column 2. For this reason i made an if statement in the custom column but it doesnt work 😞

Thanks alot for help and tipps.

Best wishes

Donb

[DONB87]

Thansk a lot @FreemanZ  it works!! 

[tamerj1]

Hi @DONB87 
I think you need to add each, like

each if [#"Column1"] = null then [#"Column2"] else [#"Column1"] 

[FreemanZ · Accepted solution]

hi @DONB87 

how about the other way around:

if [col1] <> null

then [col1]

else [col2]