I have two tables where there is a many to many relationship.
I want to see where the IDs match and are also occurring more than once:
Table 1: Table 2: Output Table
ID ID ID
12 10 14
Many thanks for looking!
Go to Solution.
Many thanks for that!
It's put me on the right track.
View solution in original post
Output Table =VAR T1 =FILTER ('Table 1',COUNTROWS (CALCULATETABLE ( 'Table 1', ALLEXCEPT ( 'Table 1', 'Table 1'[ID] ) )) > 1)VAR T2 =FILTER ('Table 2',COUNTROWS (CALCULATETABLE ( 'Table 2', ALLEXCEPT ( 'Table 2', 'Table 2'[ID] ) )) > 1)RETURNDISTINCT ( INTERSECT ( T1, T2 ) )
Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!