EXCEPT DAX Function in Power BI

EXCEPT DAX function is used to returns the rows of one table which do not present in another table. It comes under Table Manipulation DAX Functions category.

Syntax:

EXCEPT(<table_expression1>, <table_expression2>

Refer similar DAX Post – INTERSECT, UNION

Description:

Note:

• 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 utilize these two tables for practical purposes.

Table-1

Table-2

Follow these steps-

Step-1: Create a new table- Go to Modeling tab and click on table icon.

Create table

Step-2: DAX formula screen appears, write DAX formula here and press enter key.

Except = EXCEPT('Table-1', 'Table-2')

EXCEPT DAX

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.

EXCEPT DAX Output

Now change the Table sequence under EXCEPT DAX function-

Except DAX = EXCEPT('Table-2', 'Table-1')

EXCEPT-DAX

See the output, it will return the rows of Table-2 which do not appear in Table-1.

EXCEPT – DAX Output-2

Refer similar DAX Post – INTERSECT, UNION

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.