LOOKUPVALUE with AND's

[Anonymous]

Hey everyone!

I am trying to make us of LOOKUPVALUE. I have the following data:

Table1

Employee	MonthInCalendar	Count
Peter Parker	March 2021	5000
Bruce Wayne	March 2021	3000
Peter Parker	April 2021	6000

Table2

Employee	MonthInCalendar	NewColumn
Peter Parker	March 2021
Bruce Wayne	March 2021

I am trying to use a LOOKUPVALUE that to copy the value only if the MonthInCalendar and the Employee is the same. I can't only check the name or the month as it would not produce the results I want. Is there a way to use the & to check both columns in the LOOKUPVALUE?

[Greg_Deckler · Accepted solution]

@Anonymous That is the default behavior of LOOKUPVALUE. All search pairs must be met. 

LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

So, something like:

New Column = LOOKUPVALUE('Table1'[Count], 'Table1'[Employee], [Employee], 'Table1[MonthInCalendar], [MonthInCalendar])