Looking for same events in two fact tables and returning information

[Anonymous]

Hi, 

I'm struggling for some time on this problem. I have two fact tables with Event ID and Date. If the Event ID and Date from Table 2 are equal to those in Table 1, I can assume the event is the same so I need to extract the Location information from Table 2 to the same event in Table 1. If the event in Table 1 isn't in Table 2, Location information is left blank. 

Can you help me to develop a DAX function to this new column which solves my problem?

Example: 

Table 1:

Event ID	Date
1	04/03
1	04/01
5	04/01
12	04/01
12	04/02

Table 2:

Event ID	Date	Location
1	04/03	A
1	04/02	B
5	04/02	A
12	04/02	C

Desired Table 1:

Event ID	Date	New column - Location
1	04/03	A
1	04/01
5	04/01
12	04/01
12	04/02	C

Thanks so much!

[amitchandak · Accepted solution]

@Anonymous , Create a new column in table 1

New column - Location = maxx(filter('Table 2','Table 2'[Event ID] = 'Table 1'[Event ID] && 'Table 2'[Date]= 'Table 1'[Date]),'Table 2'[Location])