lookup value based on a condition

[jmansour4567]

Good day, I have a question about creating a lookup column in power bi.

Table A is my response table and Table B is my submissions table where the lookup value will be calculated please see below:

Table A Response	Table A Type	Table A B.ID
Place 1	Place	1
Place 2	Place	2
Person 1	Person	1
Person 2	Person	2
Time 1	Time	1
Person 3	Person	3

Inorder to calculate Table B (Person **Lookup), I need to filter Table A Type for "Person" AND match Table A B.ID to Table B ID

Table B ID	Table B (Person **Lookup)
1	Person 1
2	Person 2

Im fairly new to DAX so I am not quite sure do this. 

Any help would be much appreciated! Thank you all in advance!

Cheers

[jmansour4567]

Brilliant! thank you!

[amitchandak · Accepted solution]

@jmansour4567 , New column in table B

maxx(filter(TableA, TableA[B.ID]  = TableB[ID] && TableA[Type] = "Person") , TableA[Response])

Change column name as per need