Forum Discussion
Finding Intersection between two columns
I have two tables: Table1: ID Letter 1 a 2 b 3 c 4 d 5 e 6 f 7 g 8 h 9 i And a virtual table, Table 2 ID 1 2 How do I find...
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new table.
Intersect table =
CALCULATETABLE ( Table1, INTERSECT ( VALUES ( Table1[ID] ), Table2 ) )