Appendix A. DAX Functions Reference

THIS APPENDIX LISTS FUNCTIONS available in DAX along with their syntax.

Statistical Functions

Statistical functions aggregate and compute data, returning a scalar value. Usually, these functions operate on all the rows of the table containing the specified column, which has to be of numeric or date type. The A suffix identifies functions that also operate on any other type of columns. The X suffix identifies functions that allow aggregation of the result of an expression applied to each row of the specified table.

Table A-1. Statistical Numeric Functions Returning a Scalar Value

Function

Description

AVERAGE( <column> )

Returns the arithmetic mean of all the numbers in a column. <column> must be of date or number ...

Get Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.