Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 , 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |