EXCEPT – comparison of tables – finding of additional rows (DAX – Power Pivot, Power BI)
This is about the EXCEPT function in DAX. This functions takes two tables, compares them and show the result, which is a table containing rows present in the first table and NOT present in the second table.
You can do something similar with Inner query connection in Power query or in DAX queries.
If you want to see the common rows (now different rows), use INTERSECT.
Let´s use these two tables. In one of them there are employees working in some company this month. In the second table there are employees working there last time. We need the list of new people - working in the company in this month only (the additional rows).
Let´s upload both tables to Power BI. Then create new table and use EXCEPT to compare them. The syntax is totally simple - just write the names of both tables.
The result table contains additional rows.
EXCEPT needs the same number of columns in both tables. It sees the rows identical if they have values in all columns identical.