# MDX Operator 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.

## In This Section

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. |