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...
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")
ryan_mayu
Super User
Super UserAnonymous
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")