Forum Discussion
Solved
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...
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 , 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
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