Forum Discussion
Remove duplicates from union and can select which column values should retain
Seeking help regarding the union functions. I wanted to remove the duplicates from Active List table with the same employee ID from Separated List table and retain the value from Separated List table...
amitchandak
Super User
Super Userphil_galvz , Try like
Summarize(
UNION(
SELECTCOLUMNS('ACTIVE LIST',"Employee ID",'ACTIVE LIST'[ID No.],"Employee Name",'ACTIVE LIST'[Employee Name],"Status",'ACTIVE LIST'[Status]),
SELECTCOLUMNS('SEPARATED LIST',"Employee ID",'SEPARATED LIST'[ID No.],"Employee Name",'SEPARATED LIST'[Employee Name],"Status",'SEPARATED LIST'[Status])), [Employee ID], [Employee Name], "Status", max([Status]))
Hi Amit,
Tried your suggestions but I have errors encountered.