| title | Set Operators | Microsoft Docs |
|---|---|
| ms.date | 06/04/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
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)