additions and omissions between different versions of a dataset

[Anonymous]

I receive a weekly data set of document numbers that i consolidate using power query, the consolidated data set is used to produce performance trends.  However I now need to be able to count numbers of documents that are either being added week or ommited week on week. 

for example using Excel and countifs when I compare 2 consecutive versions, say Version 11 to version 12,  I can find 74 document numbers in V12 that were not present in V11, and 150 that were present in V11 but are no longer in V12.

Ideally I want to be able to list the new or ommited documents as well as get the counts.

[Anonymous]

Both, I'd like to show the count of differences, as well as alow users to drill through to see the actual list of new or missing document numbers

[tamerj1]

@Anonymous 

Do you want to count or list the added or omitted documents? How are you planning to present the results?

[Anonymous]

re how am i planning to present the results, the counts probably as a card on an overview page, but the list of new documents and Missing documents, probably as tables.

[tamerj1]

@Anonymous 
Can you please provide one example? I the list table shall be based on which two versions?