Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
WolfDog23
Frequent Visitor

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

‎04-19-2023 11:52 AM

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!

Labels:
Message 1 of 3
432 Views
0
1 ACCEPTED SOLUTION
olgad
Super User
Super User

‎04-19-2023 12:00 PM

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

Message 2 of 3
426 Views
0
2 REPLIES 2
olgad
Super User
Super User

‎04-19-2023 12:00 PM

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
Message 2 of 3
427 Views
0
WolfDog23
Frequent Visitor
In response to olgad

‎04-19-2023 12:53 PM

Worked. Thank you!

Message 3 of 3
383 Views
0

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.

View All
Top Kudoed Authors
View All