Forum Discussion
How to apply multiple arguments in a Lookup or Related statement
Thanks. This did answer the question. Below is the syntax for other self-learners. I created a column named Alloc in the Sales table using the below:
Alloc = LOOKUPVALUE(SalesAllocation[ServicAllocationAmt],
SalesAllocation[DealID],Sales[DealID],
SalesAllocation[ServiceID],"CDT", blank())How would this read if I wanted to express an aditional value for the SalesAllocation[ServiceID]. Suppose I wanted to say both "CDT" and "ADT" met the criteria. What would be that syntax?
Community ChampionDonnyboy LOOKUPVALUE supports multiple search arguments: LOOKUPVALUE function (DAX) - DAX | Microsoft Learn. Also, you can achieve the same thing using MAXX(FILTER(...),...)
Thanks. This did answer the question. Below is the syntax for other self-learners. I created a column named Alloc in the Sales table using the below:
Alloc = LOOKUPVALUE(SalesAllocation[ServicAllocationAmt],
SalesAllocation[DealID],Sales[DealID],
SalesAllocation[ServiceID],"CDT", blank())
How would this read if I wanted to express an aditional value for the SalesAllocation[ServiceID]. Suppose I wanted to say both "CDT" and "ADT" met the criteria. What would be that syntax?