topic Re: Issue with Costum Column with if condition in DAX Commands and Tips

Issue with Costum Column with if condition

DONB87 — Wed, 08 Feb 2023 10:45:56 GMT

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

Re: Issue with Costum Column with if condition

FreemanZ — Wed, 08 Feb 2023 11:11:58 GMT

hi DONB87

how about the other way around:

if [col1] <> null

then [col1]

else [col2]

Re: Issue with Costum Column with if condition

tamerj1 — Wed, 08 Feb 2023 12:27:06 GMT

Hi DONB87
I think you need to add each, like

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

Re: Issue with Costum Column with if condition

DONB87 — Thu, 09 Feb 2023 09:53:50 GMT

Thansk a lot FreemanZ it works!!