cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent 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 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

1 ACCEPTED SOLUTION
Super User

Hi,

Try this calculated column formula

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

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
3 REPLIES 3
Super User

Hi,

Try this calculated column formula

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

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

@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.

Community Champion

Hi @CAT6xx

try a simple column

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

do not hesitate to give a kudo to useful posts and mark solutions as solution

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors