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 type. ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.