---
title: "MDX Operator Reference (MDX) | Microsoft Docs"
ms.custom: ""
ms.date: "03/02/2016"
ms.prod: "sql-server-2016"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "analysis-services"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
dev_langs: 
  - "kbMDX"
helpviewer_keywords: 
  - "Multidimensional Expressions [Analysis Services], operators"
  - "operators [MDX]"
  - "MDX [Analysis Services], operators"
ms.assetid: 1cdb8c31-a5f6-4430-b509-f81344f4622a
caps.latest.revision: 34
author: "Minewiskan"
ms.author: "owend"
manager: "erikre"
---
# MDX Operator Reference (MDX)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx_md](../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  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)