Append Tables as New No Duplicates Three Unique Columns

I have Three tables "ShippedDel24", "ShippedDel23" and "DailyMonth". 

ShippedDel24 is all deliveries that shipped year to date in 2024.

ShippedDel23 is all deliveries that shipped in 2023

DailyMonth is a report that is run daily for the current month. It is a month to date type report.

All of these reports have the same headers with about 25 different columns.

When I try to Append these tables together I am getting duplicate values for the current month. The issue is the current month that is in ShippedDel24 and the DailyMonth report have some of the same data. I cannot change how the DailyMonth report is run. So, I am wanting yo use Power Query to Append the reports and remove any duplicates. 

One of the issues is my deliveries have more than one item shipped to them but three of the columns and be used in each row to determine if they're duplicated or not.  

The columns are Delivery, Material, and Item but when I try to tell it to remove duplicates from these columns it doesn't work. 

= Table.Distinct(Source, {"Delivery", "Material", "Item"})

All of my columns are the same data type.

Also, for some reason when I append my Queries as New it duplicates two of my columns and enters a null value in each row for those two columns.

Please help

Thanks

I am not sure if "Appending Queries" is the corrent way to try and do what I am doing or if there is anoter way.