How to confirm if a value in one column of a data source appears in column of another data source?

[Hendri_Fourie]

Good day,

SOS!

I have two reports, Report 1 contains amongst others Delivery Note numbers generated in our MRP, and Report 2 contains the Delivery Note numbers of the corresponding documents saved in our Document Management System. I would like to see which of the Delivery Note numbers generated does not make it into our Document Management System. This would be one of the KPI's of the team managing our PODs.
(I am currently running these reports in Excel - but want to migrate to Power BI... It was however high time to stop and ask for directions - it appears I am finding difference ways not to get the results).

Report 1 (Extract)

Report 2 (Extract)

Note that the column headers are not the same (I can change that though). Report 2 might have duplicate entries (in some cases we have hard copies and SOG soft copies - customer specific), sometime null values (where due to issues OCR might have have indexed the entries correctly).

What syntax should I consider to get either a Yes / No or True / False returned? I would also like to graphically display this.

Will appreciate help.

Hendri