Filter unique names and compare tables to find non-matching

[Anonymous]

Hello,

I have the following 2 tables loaded in Power BI. I have a calendar table connected to the Submissions table. The calendar table has a current week offset column and i would like to use it to filter for the previous week submissions, so, current week offset value = -1.

The objective is to filter all unique student names from the Submissions table for the previous week. Then compare this list with the Reference table to find the names not in that list. The non-matching names should then be added into a new table called Non-matching. Ideally, if it's possible to do this all in Power Query? Any help is much appreciated!

Here is the download link to my PBIX file (click the download icon at the top-right corner of the window): https://drive.google.com/file/d/1qD9Q_3K97jB9t3pgQAF2i5FeAF9Rw4bP/view?usp=sharing

[davehus · Accepted solution]

Hi @Anonymous ,

See updated file below.

https://drive.google.com/file/d/1eoawy7O6zwHmFcuXrzwqEWYpWU_H_i8y/view?usp=sharing

[Anonymous]

Hi @davehus Thanks for your reply. But it is not correct. Your result gives only one name: Frei Paulo.

Here is the complete list of submissions for last week (from Monday to Sunday):

The list of unique names from the list above:

Luntas
Zagrodno
Frei Paulo
Gangarampur
Cosamaloapan de Carpio
Seedorf
Bellegarde

The reference list has 11 distinct names. So, the result in the non-matching table should have 4 names. I have updated the original PBIX file in the first post to make it simpler.

[davehus]

Hi @Anonymous , Can you check it now, i've updated my file too.