Looking up Multiple values

[Anonymous]

I have 3 tables as shown above,
I have a 1-Many relationship between Table2 and Table 1,
another 1-Many relationship between Table2 and Table 3

I want to create a tabular visual in power bi where i want to add Name,ID,Date & Campaign name
The table should look like below

is it possible to lookup the multiple values of campaign and Date from table 1 using DAX assuming relationship between table 1 and table 2 is not active 

PS: This is not my original daaset, this is a sample dateaset created in excel as i cant show my original dataset here for data privacy.
 

[Anonymous]

Works!! thank you Ryan 

[ryan_mayu · Accepted solution]

@Anonymous 

is this what you want?

Measure = CALCULATE(max(Table2[Customer Name]),FILTER(Table2,Table2[ID]=MAX(Table1[ID])))