Search the same occurrence in another table by ID

[Anonymous]

Hello!
I have two tables that follow this structure:
Table1

ID	Type
1	A
2	C
3	B
4	C

Table2

ID	Type
1	A
1	B
2	B
2	A
3	C

I want to create a column in Table1 that will check if the corresponding ID in Table2 has the Type column value in at least one of the corresponding rows and report "Yes" or "No". The expected result would be something like this

Table1

ID	Type	Match
1	A	Yes
2	C	No
3	B	Yes
4	C	No

[ryan_mayu · Accepted solution]

@Anonymous 

why 3B is Yes? should that be NO?

you can try below DAX

Column =

VAR _check=maxx(FILTER(Table2,'Table2'[ID]=Table1[ID]&&Table2[   Type  ]=Table1[   Type  ]),Table2[ID])

return if(ISBLANK(_check),"No","Yes")