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.