INTERSECT DAX function – compares two tables and returns common rows. The output of INTERSECT function is a table with the common rows. Its comes under Table Manipulation DAX Functions category.
|1||Table_expression||Any DAX expression that returns a table.|
- A table that contains all the rows in table_expression1 that are also in table_expression2
- 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.
Intersect DAX= INTERSECT('Table-1', 'Table-2')
Step-3: You can see the new created table under fields, and it will return the common rows of Table-1 and Table-2.
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.