Reply
WolfDog23
Frequent Visitor
Partially syndicated - Outbound

How to get value from 3rd column when 1st and 2nd are null

Hi,

I'm looking to find a DAX expression that will allow me to pull the value from a column X when column Y and Z are both null and not have it pull when y or z has a value in it. Appraciate the help in advance!

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Syndicated - Outbound

If(isblank(columny) && isblank(columnz), columnx) 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

2 REPLIES 2
olgad
Super User
Super User

Syndicated - Outbound

If(isblank(columny) && isblank(columnz), columnx) 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Syndicated - Outbound

Worked. Thank you!

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)