Set Operators
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. |
See Also
MDX Function Reference (MDX)
MDX Operator Reference (MDX)
Operators (MDX Syntax)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for