Lookup & filter together

[gauravnarchal]

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_key	name	value
1015422	FF33
1015422	FF46
1015422	FF47
1015422	Traveller Guid
1015422	FF2	Apple
1015422	FF20	E-MAIL
1015422	FF16	Test
1015422	FF1	June
1015422	FF10	NA
1015422	FF13	NA
1015422	FF3	NA

Table 2

unique_key	Supplier Code	FF20
1015422	12154125

[v-yohua-msft · Accepted solution]

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.

[speedramps]

I assume you are Power BI novice if you dont know how to build lookup relationships yet.

Please try do this training before asking basic questions. Thank you ....

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

and

https://www.youtube.com/watch?v=sW5LoDA1ssM