title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
---|---|---|---|---|---|---|---|---|---|
MDX Operator Reference (MDX) |
MDX Operator Reference (MDX) |
kfollis |
kfollis |
kfollis |
02/17/2022 |
sql |
analysis-services |
reference |
mdx |
The Multidimensional Expressions (MDX) language supports arithmetic, logical, comparison, set, string, and unary operators. The following table lists the supported operators and their descriptions.
Topic | Description |
---|---|
-- (Comment) (MDX) | Indicates comment text that is provided by the user. |
- (Except) (MDX) | Performs a set operation that returns the difference between two sets, removing duplicate members. |
- (Negative) (MDX) | Performs a unary operation that returns the negative value of a numeric expression. |
- (Subtract) (MDX) | Performs an arithmetic operation that subtracts one number from another number. |
* (Crossjoin) (MDX) | Performs a set operation that returns the cross product of two sets. |
* (Multiply) (MDX) | Performs an arithmetic operation that multiplies two numbers. |
(Divide) (MDX) | Performs an arithmetic operation that divides one number by another number. |
^ (Power) (MDX) | Performs an arithmetic operation that raises one number by another number. |
Comment (MDX) | Indicates comment text that is provided by the user. |
(Comment) (MDX) | Indicates user-provided text. |
: (Range) (MDX) | Performs a set operation that 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. |
+ (Add) (MDX) | Performs an arithmetic operation that adds two numbers. |
+ (Positive) (MDX) | Performs a unary operation that returns the positive value of a numeric expression. |
+ (String Concatenation) (MDX) | Performs a string operation that concatenates two or more character strings, tuples, or a combination of strings and tuples. |
+ (Union) (MDX) | Performs a set operation that returns a union of two sets, removing duplicates. |
< (Less Than) (MDX) | Performs a comparison operation that determines whether the value of one MDX expression is less than the value of another MDX expression. |
<= (Less Than or Equal To) (MDX) | Performs a comparison operation that determines whether the value of one MDX expression is less than or equal to the value of another MDX expression. |
<> (Not Equal To) (MDX) | Performs a comparison operation that determines whether the value of one MDX expression is not equal to the value of another MDX expression. |
= (Equal To) (MDX) | Performs a comparison operation that determines whether the value of one MDX expression is equal to the value of another MDX expression. |
> (Greater Than) (MDX) | Performs a comparison operation that determines whether the value of one MDX expression is greater than the value of another MDX expression. |
>= (Greater Than or Equal To) (MDX) | Performs a comparison operation that determines whether the value of one MDX expression is greater than or equal to the value of another MDX expression. |
AND (MDX) | Performs a logical conjunction on two numeric expressions. |
IS (MDX) | Performs a logical comparison on two object expressions. |
NOT (MDX) | Performs a logical negation on a numeric expression. |
OR (MDX) | Performs a logical disjunction on two numeric expressions. |
XOR (MDX) | Performs a logical exclusion on two numeric expressions. |