topic Re: additions and omissions between different versions of a dataset in DAX Commands and Tips

additions and omissions between different versions of a dataset

Anonymous — Mon, 27 Feb 2023 11:16:04 GMT

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.

Re: additions and omissions between different versions of a dataset

tamerj1 — Mon, 27 Feb 2023 12:55:44 GMT

Anonymous

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

Re: additions and omissions between different versions of a dataset

Anonymous — Mon, 27 Feb 2023 15:51:53 GMT

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

Re: additions and omissions between different versions of a dataset

Anonymous — Mon, 27 Feb 2023 15:54:43 GMT

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.

Re: additions and omissions between different versions of a dataset

tamerj1 — Mon, 27 Feb 2023 17:19:22 GMT

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