Filter table by table

[Marcin]

Hi,

I am looking for soultion for this case.

Assume I have two tables like this :

Table1				Table2
Id	Name			Id	Value
1	Adam			5	40
2	John			6	45
3	Peter			3	55
4	Megan			4	42

What I would like to get is table table one to be filtered out with ID values from table2 . ( In sql I would use "ID is not in" )

So my result will be : 

Id	Name
1	Adam
2	John

So values with IDs 3 and 4 are filtered out becasue they exist in column Id of table2 

[AlB · Accepted solution]

Hi @Marcin 

You can create a new calculated table:

NewTable =
FILTER ( Table1, NOT Table1[Id] IN DISTINCT ( Table2[Id] ) )