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

Topic | Description |
---|---|

Indicates comment text that is provided by the user. | |

Performs a set operation that returns the difference between two sets, removing duplicate members. | |

Performs a unary operation that returns the negative value of a numeric expression. | |

Performs an arithmetic operation that subtracts one number from another number. | |

Performs a set operation that returns the cross product of two sets. | |

Performs an arithmetic operation that multiplies two numbers. | |

Performs an arithmetic operation that divides one number by another number. | |

Performs an arithmetic operation that raises one number by another number. | |

Indicates comment text that is provided by the user. | |

Indicates user-provided text. | |

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

Performs an arithmetic operation that adds two numbers. | |

Performs a unary operation that returns the positive value of a numeric expression. | |

Performs a string operation that concatenates two or more character strings, tuples, or a combination of strings and tuples. | |

Performs a set operation that returns a union of two sets, removing duplicates. | |

Performs a comparison operation that determines whether the value of one MDX expression is less than the value of another MDX expression. | |

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

Performs a comparison operation that determines whether the value of one MDX expression is not equal to the value of another MDX expression. | |

Performs a comparison operation that determines whether the value of one MDX expression is equal to the value of another MDX expression. | |

Performs a comparison operation that determines whether the value of one MDX expression is greater than the value of another MDX expression. | |

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

Performs a logical conjunction on two numeric expressions. | |

Performs a logical comparison on two object expressions. | |

Performs a logical negation on a numeric expression. | |

Performs a logical disjunction on two numeric expressions. | |

Performs a logical exclusion on two numeric expressions. |