Forum Discussion

Frequent Visitor

4 years ago

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...

Super User

4 years ago

Hi there,

Based on what you've posted, I would suggest using TREATAS to apply Table2 as a filter (I'm assuming Table2 has a single column).

For example, if you need an expression that returns the rows of Table1

CALCULATETABLE (
    Table1,
    TREATAS ( Table2, Table1[ID] )
)

What is the ultimate goal, i.e. where would the intersecting rows of Table1 be used?

Regards,

Owen