comparing two data sets

[Gopinath_iyer]

Hi 

I have two excel data and i want to compare both. Employee number is common in both files but the number of columns are not same in both the files.

Eg Emp table has list of employees (emp numbers are repeating because of month wise data) and master file has two columns only emp number and name.

I want to find the list of emps present in Emp table and not present in Master table and vice versa.

Can this be achieved?

regards,

Gopi

[amitchandak · Accepted solution]

@Gopinath_iyer , Use except in DAX or Antijoin in Power Query merge

New table = except(distinct(Table[Emp]), Distinct(Table2[Emp]) )

merge: https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Gopinath_iyer]

Thanks for the suggestion and sorry for replying late.

AntiJoin is not working when we filter the data in report with slicer filter.

And when i try to use the DAX i get error as the number of columns are not same in both excel.

Regards,

Gopi