Merging tables

[akhaliq7]

When merging two tables i used duplicate for the dim table and then removed duplicates and then I attempted to merge using 3 columns: make, model and derivative. I selected all 3 in the merge but only 10% of the rows matched. When i jist selected make then 95% of the rows matched. Am i doing anything wrong in my creating dim table process.

[Icey]

Hi @akhaliq7 ,

Could you share us some screenshots or sample data to help understand your scenario? For data security, please remove sensitive information.

Referencce: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

[Fowmy]

@akhaliq7 

It's not clear without seeing your data or any screenshots.