Forum Discussion

matthewtjy's avatar
matthewtjy
Icon for Helper I rankHelper I
5 years ago
Solved

Create Table By Excluding Rows From Another Table

Hi, I have currently two tables, Table1 and Table2. Table1 is the main data set; Table2 is derived from Table1 using filters to only include rows where TypeID="Personal" i.e. Table2 = FILTER( 'T...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    For creating a new table.

     

    Table3 =
    FILTER ( Table1, NOT ( Table1[WorkplaceID] IN VALUES ( Table2[WorkplaceID] ) ) )

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

For creating a new table.

 

Table3 =
FILTER ( Table1, NOT ( Table1[WorkplaceID] IN VALUES ( Table2[WorkplaceID] ) ) )

matthewtjy's avatar
matthewtjy
Icon for Helper I rankHelper I
5 years ago

Works like a charm, thanks Jihwan!