Forum Discussion
Search the same occurrence in another table by ID
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 |
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")
1 Reply
ryan_mayuSuper User
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")