Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
2 years ago
Solved

Lookup & filter together

Hello

 

How can I bring the data from Table 1 to Table 2 using lookup and filter?

 

If the unique key of table 1 matches the unique key of table 2 & name of table 1 is FF20 return the value from Table 1 to Table 2.

 

Table 1 

 

unique_keynamevalue
1015422FF33 
1015422FF46 
1015422FF47 
1015422Traveller Guid 
1015422FF2Apple
1015422FF20E-MAIL
1015422FF16Test
1015422FF1June
1015422FF10NA
1015422FF13NA
1015422FF3NA

 

Table 2

 

unique_keySupplier CodeFF20
101542212154125 
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, gauravnarchal 
    Based on the information you gave, I have created two tables, and the following is my model view.

     

     

    Please following these steps:

     

    Create a new column named FF20, Here's the DAX expression:

     

    FF20 = MAXX(FILTER(Table1,Table1[name]="FF20"&&Table1[Unique_key]=Table2[Unique_key]),[value])

     

    The following is my preview.

     

     

     

    How to Get Your Question Answered Quickly 

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies