Forum Discussion

Marcin's avatar
Marcin
Helper V
7 years ago
Solved

Filter table by table

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 ...
  • AlB's avatar
    7 years ago

    Hi Marcin 

    You can create a new calculated table:

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