Column return if column value is 0

[CAT6xx]

I looking for a DAX expression or another way to create a "New Column" that returns the value from "Column 2" if "Column 1" value is 0 and value from

"Column 1" if "Column 2" is 0.

Any help would be great!

Column 1	Column 2		New Column
12	0		12
0	43		43
43	0		43
0	22		22
0	56		56
54	0		54
0	77		77

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=MAX(Data[Column 1],Data[Column 2])

Hope this helps.

[V-pazhen-msft]

@CAT6xx 

Use @az38 's DAX but remove "undefined", because it is text datatype, Column 1 and Column 2 are numerical numbers. I guess you would return an error of variant datatype. 

New Column = SWITCH(TRUE(),
[Column 1] = 0, [Column 2],
[Column 2] = 0, [Column 1])

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

Hi @CAT6xx 

try a simple column

Column = SWITCH(TRUE(),
[Column 1] = 0, [Column 2],
[Column 2] = 0, [Column 1],
"Undefined"
)