Compare two table column value and keep duplicate also

Hello asrarkhan26,

1. Create a new table that combines the data from both tables using the "Append Queries" function in Power Query. In the Power Query Editor, go to the "Home" tab and select "Append Queries". Select the Week 1 and Week 2 tables, and then click "OK". This will create a new table that combines the data from both tables.

2. Create a calculated column in the new table that compares the vendors for each Name.

Vendor Matched = 
IF(ISBLANK([Vendor Week 2]), "Not Matched", 
   IF([Vendor Week 1] = [Vendor Week 2], "Matched", "Not Matched"))

3. Create a table or matrix visual that displays the Name, Vendor Week 1, Vendor Week 2, and Vendor Matched columns

This should give you a table that shows whether the vendors for each Name are matched or not, based on the data from Week 1 and Week 2.

Let me know if you have any other questions.