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 woul...
  • Ashish_Mathur's avatar
    6 years ago

    Hi,

    Try this calculated column formula

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

    Hope this helps.