Pros, apparently a simple scenerio but didn't find any source.
I populate a table with a dataset I get every month. I need two measure which calculate newly added and newly deleted records.
what I mean is that a record did exist in previous month but now it does not; and similarly added were the onese found for the first time in the current dataset. Notice that ID 10 does not exist in February as well as March, however February should be the only month where it should be counted.
Use Merge As New, but choose which merge type. You'll have to do it twice to get the two seperate tables you want. If Table 1 was your old table and Table 2 is your new table, you'll want to choose something like "Rows Only in First Table" to get the deleted rows and "Rows Only In Second Table" to get the newly added rows.