Forum Discussion

DeepDive's avatar
DeepDive
Helper IV
6 years ago
Solved

undefined

I have two tables... Both have one column .. example table 1 have id and table 2 also have id... Few ids are in both tables. Now I want to create new table using dax which shows Id that are not present in second table
Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago

    Try 

    Table = EXCEPT(First,'Second')

     

    Thanks
    Ankit Jain

    Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

2 Replies

  • AnkitBI's avatar
    AnkitBI
    Solution Sage
    6 years ago

    Try 

    Table = EXCEPT(First,'Second')

     

    Thanks
    Ankit Jain

    Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.