Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Not exist

Hello,   I have two table (Table01 and Table 02)   How I can get Table 03 that have the ID that exist in table 02 and not exist in table 01   Thanks.
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Anonymous ,

    Table = EXCEPT(DISTINCT('Table1'[Product ID]),DISTINCT('Table2'[Product ID]))
Tahreem24's avatar
Tahreem24
Super User
6 years ago

Anonymous ,

Uuse the EXCEPT() function for your requirement.

 

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

a new table
Table = EXCEPT(DISTINCT('Table1'[ProductID]),DISTINCT('Table2'[ProductID]))

as a measure
Measure = countx(EXCEPT(DISTINCT('Table1'[ProductID]),DISTINCT('Table2'[ProductID])), [ProductID])