Forum Discussion

Marcin's avatar
Marcin
Icon for Helper V rankHelper 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 ...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Marcin 

    You can create a new calculated table:

    NewTable =
FILTER ( Table1, NOT Table1[Id] IN DISTINCT ( Table2[Id] ) )
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Marcin 

You can create a new calculated table:

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