Forum Discussion

DONB87's avatar
DONB87
Frequent Visitor
3 years ago
Solved

Issue with Costum Column with if condition

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

3 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi DONB87 

    how about the other way around:
    if [col1] <> null
    then [col1]
    else [col2]
  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi DONB87 
    I think you need to add each, like

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