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
So this lookup works fine
LOOKUPVALUE can have multiple searcheshttps://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")
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021