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]))

4 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,

    Uuse the EXCEPT() function for your requirement.

     

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper 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])

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,

    Table = EXCEPT(DISTINCT('Table1'[Product ID]),DISTINCT('Table2'[Product ID]))