Microsoft Office Tutorials and References
In Depth Information
FIguRE 3-1 You can see DAX syntax in this sales table.
Using this data, you now want to calculate the margin, subtracting the TotalProductCost
from the SalesAmount. To do that, you need to write the DAX formula shown in Figure 3-2
in a new column, which you can call GrossMargin.
FIguRE 3-2 Definition of GrossMargin.
This new formula is repeated automatically for all the rows of the table, resulting in a new
column in the table. In this example, you are using a DAX expression to define a calculated
column. (Later we see that DAX is used also to define measures.) This DAX expression handles
numeric values and returns a numeric value, too.
DAX Data Types
You saw in the previous formula how to handle numeric values. DAX can perform computations
with different numeric types, of which there are five:
■ Date (datetime)
■ TRUE/FALSE (Boolean)