---
title: "MDX Operator Reference (MDX) | 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
---
# 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)](../mdx/comment-mdx-operator-reference.md)|Indicates comment text that is provided by the user.|  
|[- (Except) (MDX)](../mdx/except-mdx-operator.md)|Performs a set operation that returns the difference between two sets, removing duplicate members.|  
|[- (Negative) (MDX)](../mdx/negative-mdx.md)|Performs a unary operation that returns the negative value of a numeric expression.|  
|[- (Subtract) (MDX)](../mdx/subtract-mdx.md)|Performs an arithmetic operation that subtracts one number from another number.|  
|[* (Crossjoin) (MDX)](../mdx/crossjoin-mdx-operator-reference.md)|Performs a set operation that returns the cross product of two sets.|  
|[* (Multiply) (MDX)](../mdx/multiply-mdx.md)|Performs an arithmetic operation that multiplies two numbers.|  
|[(Divide) (MDX)](../mdx/divide-mdx-operator-reference.md)|Performs an arithmetic operation that divides one number by another number.|  
|[^ (Power) (MDX)](../mdx/power-mdx.md)|Performs an arithmetic operation that raises one number by another number.|  
|[Comment (MDX)](../mdx/comment-mdx.md)|Indicates comment text that is provided by the user.|  
|[(Comment) (MDX)](../mdx/comment-mdx-double-slash.md)|Indicates user-provided text.|  
|[: (Range) (MDX)](../mdx/range-mdx.md)|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)](../mdx/add-mdx.md)|Performs an arithmetic operation that adds two numbers.|  
|[+ (Positive) (MDX)](../mdx/positive-mdx.md)|Performs a unary operation that returns the positive value of a numeric expression.|  
|[+ (String Concatenation) (MDX)](../mdx/string-concatenation-mdx.md)|Performs a string operation that concatenates two or more character strings, tuples, or a combination of strings and tuples.|  
|[+ (Union) (MDX)](../mdx/union-mdx-operator-reference.md)|Performs a set operation that returns a union of two sets, removing duplicates.|  
|[< (Less Than) (MDX)](../mdx/less-than-mdx.md)|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)](../mdx/less-than-or-equal-to-mdx.md)|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)](../mdx/not-equal-to-mdx.md)|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)](../mdx/equal-to-mdx.md)|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)](../mdx/greater-than-mdx.md)|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)](../mdx/greater-than-or-equal-to-mdx.md)|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)](../mdx/and-mdx.md)|Performs a logical conjunction on two numeric expressions.|  
|[IS (MDX)](../mdx/is-mdx.md)|Performs a logical comparison on two object expressions.|  
|[NOT (MDX)](../mdx/not-mdx.md)|Performs a logical negation on a numeric expression.|  
|[OR (MDX)](../mdx/or-mdx.md)|Performs a logical disjunction on two numeric expressions.|  
|[XOR (MDX)](../mdx/xor-mdx.md)|Performs a logical exclusion on two numeric expressions.|  
  
## See Also  
 [MDX Language Reference (MDX)](../mdx/mdx-language-reference-mdx.md)