Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Looking up Multiple values

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 

    is this what you want?

     

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

     

2 Replies

  • Anonymous 

    is this what you want?

     

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Works!! thank you Ryan