Forum Discussion

RonaldvdH's avatar
RonaldvdH
Post Patron
2 years ago

Combining 2 tables based on unique values

I have a question and I need to combine 2 datasheets (2 different tables) based on unique values is both columns. Both tables have the column with the unique value SearchCode and however 95% of the ...
Need Help
Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

Hi, RonaldvdH 

here my data look like

table 1

 

table2 

 

 


try below code for new table

new table=
var table_1 = SUMMARIZE(Table1,Table1[id],Table1[name])
var table_2 = SUMMARIZE(Table2,Table2[id],Table2[name])
var result = EXCEPT(table_2,table_1)
return
UNION(table_1,result)

 

final result