LOOKUPVALUE

[Wecks]

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

[Stachu]

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")