Forum Discussion
Solved
Power BI Power Query Append Two table Distinct Values Only Based on two columns each row
I have two tables I need to append in excel files. The first table called "Main" and the file name is called "Yearly Shipping". This file contains data for everything shipped year to date. The sec...
No worries. You can change the line that is currently...
#"Appended Query" = Table.Combine({#"Changed Type", MtoD})to
#"Appended Query" = Table.Distinct(Table.Combine({#"Changed Type", MtoD}))The #"Changed Type" replaces the 'mainTable' in what I initially wrote while the MtoD replaces the 'mtdTable'.
No worries. You can change the line that is currently...
#"Appended Query" = Table.Combine({#"Changed Type", MtoD})to
#"Appended Query" = Table.Distinct(Table.Combine({#"Changed Type", MtoD}))The #"Changed Type" replaces the 'mainTable' in what I initially wrote while the MtoD replaces the 'mtdTable'.
Thank you for your help! This worked perfectly.