Comparing 2 columns from same table to another table

[MikeLombardi]

New to Power BI

This seems very easy but I can not figure out.

I have 2 tables A and B       I can not relate them.   I  need to add column "Lookup" to Table B.  Lookup comes from Tabe A  

See above for tables       

Table A				Table B
Fruit	Color	Amt		Fruit	Color	Lookup
Apple	R	5		Apple	R	5
Orange	O	2		Orange	O	2
Peach	O	7		Peach	O	7
Pair	R	8		Pair	R	8
				Berry	F
				Apple	R	5
				Orange	O	2
				Pair	R	8

[Greg_Deckler · Accepted solution]

@MikeLombardi - Try LOOKUPVALUE or MAXX(FILTER(...),...) like:

Lookup Column = 
  LOOKUPVALUE('TableA'[Amt],'TableA'[Fruit],[Fruit],'TableA'[Color],[Color])

or

Lookup Column = 
  MAXX(FILTER('TableA','TableA'[Fruit]=[Fruit] && 'TableA'[Color]=[Color]),'TableA'[Amt])