Forum Discussion
comparing two data sets
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
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
2 Replies
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-queryThanks 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
