EXCEPT DAX function is used to returns the rows of one table which do not present in another table. Its comes under Table Manipulation DAX Functions category.
|1||Table_expression||Any DAX expression that returns a table.|
- The two tables must have the same number of columns.
- Columns are compared based on positioning.
- This function is not supported for use in Direct Query mode.
Let’s use these two tables for practical-
Follow these steps-
Step-1: Create a new table- Go to Modeling tab and click on table icon.
Step-2: DAX formula screen appears, write DAX formula here and press enter key.
Except = EXCEPT('Table-1', 'Table-2')
Step-3: You can see the new created table under fields, and it will return the rows of Table-1 which do not appear in Table-2.
Now change the Table sequence under EXCEPT DAX function-
Except DAX = EXCEPT('Table-2', 'Table-1')
See the output, it will return the rows of Table-2 which do not appear in Table-1.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.