Hi Everyone, Just wanted to confirm my understanding of using INTERSECT. Have been going over the more advanced videos you post around INTERSECT (Video below). I think it makes sense to me. Basically INTERSECT function. When I break this down, visually it sounds like it is doing an INNER JOIN of…

@Shrik , In your example, you are correct that INTERSECT and Inner Join will give you the same results. However, the two functions will return very different results if you have duplicate records in a table. Using your example, I created Table 3, which duplicates records for customers 11 and 12. T…

Confirming my understanding of INTERSECT

DAX DAX Calculations

BrianJ September 16, 2019, 6:53pm 7

@Shrik,

Looks like we’ve been searching for much the same thing, both without any luck…

I just posted this earlier today in the Content Ideas section, based on your’s, @Nick_M’s, and my conversation:

Brian