- Excel DAX Tutorial
- DAX - Home
- DAX - Overview
- DAX - Calculated Columns
- DAX - Calculated Fields / Measures
- DAX - Editing a Calculated Field
- DAX - Deleting a Calculated Field
- DAX - Syntax
- DAX - Operators
- DAX - Standard Parameters
- DAX - Functions
- DAX - Understanding DAX Functions
- DAX - Evaluation Context
- DAX - Formulas
- Updating Results of DAX Formulas
- Updating Data in the Data Model
- DAX - Recalculating DAX Formulas
- Troubleshooting DAX Formula Recalculation
- DAX - Formula Errors
- DAX - Time Intelligence
- DAX - Filter Functions
- DAX - Scenarios
- Performing Complex Calculations
- DAX - Working with Text and Dates
- Conditional Values & Testing for Errors
- DAX - Using Time Intelligence
- DAX - Ranking & Comparing Values
- Excel DAX Useful Resources
- DAX - Quick Guide
- DAX - Useful Resources
- DAX - Discussion
Excel DAX - Operators
The following table lists some DAX operators.
| Operator Type | Symbol | Use |
|---|---|---|
| Parenthesis Operators | () | Precedence order and grouping of argument |
| Arithmetic Operators | + | Addition |
| - | Subtraction/ Sign | |
| * | Multiplication | |
| / | Division | |
| ^ | Exponentiation | |
| Comparison Operators | = | Equal to |
| > | Greater than | |
| < | Less than | |
| >= | Greater than or equal to | |
| <= | Less than or equal to | |
| <> | Not equal to | |
| Text Concatenation Operator | & | Concatenation |
| Logical Operators | && | AND |
| || | OR |
DAX operators and Excel operators behave in a similar way with some exceptions. You will learn more about DAX operators in the chapter - DAX Operators.
excel_dax_syntax.htm
Advertisements