INTERSECT DAX Function in Power BI
The INTERSECT DAX function returns the common rows between the given two tables in the function.
DAX Syntax INTERSECT(Left_Table, Right_Table)
The Left and right table can be physical or virtual tables.
Example: Let’s we have the following table named “Data1”.
Let’s we have another table named “Data2”.
Now we want the intersect of both the tables.
DAX
Table = INTERSECT(Data1, Data2)
The output of the above dax code is shown below:
