O'Reilly logo

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model by Alberto Ferrari Marco Russo and Chris Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required