Report Portal

Set functions in DAX: UNION, INTERSECT, and EXCEPT

This article describes the behavior of the DAX functions that manipulate sets; they are useful to create queries and sometimes also to author measures.

In this article we refer to “set functions” as functions that operate on sets. The three set functions available in DAX are: UNION, INTERSECT, and EXCEPT. Their behavior is very intuitive:



Tags: dax, tabular


2007-2015 VidasSoft Systems Inc.