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 ...
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.