Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Wecks
Frequent Visitor

LOOKUPVALUE

I am looking to do a LOOKUPVALUE but this a where clause. 

 

I have 2 tables.  

 

I want to look up the old pc name 

 

PCS

EMAIL|ComputerName|Status

 

USERS

USERNAME|Email

 

So this lookup works fine

 

OLDPC = LOOKUPVALUE(PCS[ComputerName], PCS[Email], USERS[Email])  
But i only want to show where the status value is OLD.
 
What would the syntax be for this where part?  if there is such a thing
1 REPLY 1
Stachu
Community Champion
Community Champion

LOOKUPVALUE can have multiple searches
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

 

you can do the following

OLDPC = LOOKUPVALUE(PCS[ComputerName], PCS[Email], USERS[Email], PCS[Status], "OLD")  

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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