INTERSECT Function (DAX)

How does the INTERSECT Function (DAX) work?

INTERSECT Function (DAX) compares two tables and find common rows. The INTERSECT function outputs a table with similar rows.

INTERSECT Formula Syntax

INTERSECT (<table_expression1>, <table_expression2>)

How do you use the INTERSECT function?

It returns the row intersection of two tables, retaining the duplicates.

Related Blog Posts

 

Considerations when using the INTERSECT function

  • Intersect is not commutative. That means, Intersect (T1, T2) can have a different result set than Intersect (T2, T1).
  • Duplicate rows are retained. That means, if a row appears in table_expression1 and table_expression2, it and all duplicates in table_expression_1 are included in the result set.
  • The column names will match the column names in table_expression1.
  • Columns are compared based on the positioning, and data comparison with no type coercion.
  • The returned table does not include columns from the tables related to table_expression1.

 

Related Video Tutorials

How-To-Use-The-INTERSECT-Function-Power-BI-DAX-Tutorial
Using the Cross Join function
How-To-Create-Tables-Combining-UNION-ROW-Function-Power-BI-DAX

Formula examples using the INTERSECT function

= SUMX (INTERSECT (SalesOldData,SalesNewData),[Sales Amount]) 
 

Related DAX Functions

EXCEPT
UNION
RELATED

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI