Microsoft Office Tutorials and References
In Depth Information
TABLE 3-1 Operators.
Operator Type
Symbol Use
Example
Parenthesis
( )
Precedence order and
grouping of arguments
(5 + 2) * 3
Arithmetic
+
-
*
/
Addition
Subtraction/negation
Multiplication
Division
4 + 2
5 – 3
4 * 2
4 / 2
Comparison
=
<>
>
>=
<
<=
Equal to
Not equal to
Greater than
Greater than or equal to
Less than
Less than or equal to
[Country] = “USA”
[Country] <> “USA”
[Quantity] > 0
[Quantity] >= 100
[Quantity] < 0
[Quantity] <= 100
Text concatenation
&
Concatenation of strings
“Value is “ & [Amount]
Logical
&&
AND condition between two
Boolean expressions
OR condition between two
Boolean expressions
NOT operator on the
Boolean expression that
follows
[Country] = “USA” && [Quantity]
> 0
[Country] = “USA” || [Quantity] > 0
! ([Country] = “USA”)
||
!
DAX Values
You have already seen that you can define a value through a literal (like “USA” and 100) or
through a reference to a column of a table. Although using literals is straightforward, the
syntax for referencing a column needs some attention. Here is the basic syntax:
'Table Name'[Column Name]
The table name can be enclosed in single quote characters. Most of the time, quotes can be
omitted if the name does not contain any special characters, such as spaces. In the following
formula, for example, the quotes can be omitted:
TableName[Column Name]
The column name, on the other hand, always needs to be enclosed in square brackets. Please
note that the table name is optional and can be missing. If the table name is omitted, the
column name is searched in the current table, which is the one to which the calculated column or
measure belongs. However, we strongly suggest that you always specify the complete name
(table and column) to avoid any confusion.
Search JabSto ::




Custom Search