Forum Discussion
Gopinath_iyer
Helper II
Helper IIcomparing 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
amitchandak
Super User
Super UserGopinath_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_iyerThanks 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