Forum Discussion
CAT6xx
6 years agoFrequent Visitor
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...
- 6 years ago
Hi,
Try this calculated column formula
=MAX(Data[Column 1],Data[Column 2])
Hope this helps.
Ashish_Mathur
6 years agoSuper User
Hi,
Try this calculated column formula
=MAX(Data[Column 1],Data[Column 2])
Hope this helps.