Microsoft Office Tutorials and References
In Depth Information
As you can for the year-to-date calculation, you can also define quarter-to-date and
monthto-date calculations with built-in functions, as in these measures:
QtdLineTotal = TOTALQTD( SUM( SalesOrderDetail[LineTotal] ),
MtdLineTotal = TOTALMTD( SUM( SalesOrderDetail[LineTotal] ),
In Figure 7-39, you can see the year-to-date and quarter-to-date measures used in a PivotTable.
Note that the quarter-to-date measure makes the year total equal to the last quarter of the year.
FIguRE 7-39 The year-to-date and quarter-to-date measures side-by-side with a regular measure.
To calculate a year-to-date measure over the fiscal year, you need to use an optional parameter
that specifies the end day of the fiscal year. For example, you can calculate the fiscal year-to-
date for LineTotal by using the following expression:
FiscalYtdLineTotal = TOTALYTD( SUM( SalesOrderDetail[LineTotal] ),