The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
as the title says - I am looking for most effective way to see if ID from one table is in another table in the column ID. I know there is INTERSECT but maybe there are better approaches, faster. My measure get clogged when I reference to this particular one later on
INTERSECT is the fastest. You can try TREATAS but that will be slower.