Forum Discussion
Solved
Column return if column value is 0
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 woul...
Hi,
Try this calculated column formula
=MAX(Data[Column 1],Data[Column 2])
Hope this helps.
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.