Union: The UNION function in DAX combines two tables by stacking one on top of the other. It returns all rows from both tables, including duplicates.
Except: The EXCEPT function in DAX returns all rows from the first table that are not present in the second table. It excludes any rows that are present in both tables.
Intersect: The INTERSECT function in DAX returns all rows that are present in both tables. It excludes any rows