| title | Set Operators |
|---|---|
| description | Set Operators |
| ms.date | 02/17/2022 |
| ms.service | sql |
| ms.subservice | analysis-services |
| ms.topic | reference |
| ms.custom | mdx |
In Multidimensional Expressions (MDX), set operators perform operations on members or sets, and return a set. You often use set operators as an alternate to several set functions in MDX expressions.
MDX supports the set operators listed in the following table.
| Operator | Description |
|---|---|
| - (Except) | Returns the difference between two sets, removing duplicate members. This operator is functionally equivalent to the Except function. |
| * (Crossjoin) | Returns the cross product of two sets. This operator is functionally equivalent to the Crossjoin function. |
| : (Range) | Returns a naturally ordered set, with the two specified members as endpoints and all members between the two specified members included as members of the set. |
| + (Union) | Returns a union of two sets, excluding duplicate members. This operator is functionally equivalent to the Union (MDX) function. |
MDX Function Reference (MDX)
MDX Operator Reference (MDX)
Operators (MDX Syntax)