Forum Discussion

CAT6xx's avatar
CAT6xx
Frequent Visitor
6 years ago
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 would be great!

 

Column 1Column 2 New Column
120 12
043 43
430 43
022 22
056 56
540 54
077 77

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Try this calculated column formula

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

    Hope this helps.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    Try this calculated column formula

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

    Hope this helps.

     

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi CAT6xx 

    try a simple column

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