Pull new rows from two similar tables

[Anonymous]

I have two duplicate tables, but one of the tables has around 80 new records that I want to pull out and create a new table just for these added records.  The IDs for both of these tables are the same, so what I need is DAX to only select rows from the second table where the ID does not match the ID from the first table.  I dont know why I cant wrap my head around this one.

Thanks for the help

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

Try using EXCEPT(), it is pretty cool!

Return value

A table that contains the rows of one table minus all the rows of another table.

https://docs.microsoft.com/en-us/dax/except-function-dax

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

 Thanks for this.  This is exactly what I need.  I was going to build a LEFT OUTER JOIN and figure out how to select nulls from that, etc, but this is much simpler.  Thanks again