Microsoft® PowerPivot for Excel® 2010

Appendix A. DAX Functions Reference

This appendix lists functions available in DAX, complete with their syntax. You can find the complete syntax of DAX functions at

http://technet.microsoft.com/en-us/library/ff452127.aspx

which is part of the complete DAX Reference in the documentation at

http://technet.microsoft.com/library/ee835533.aspx.

Statistical Functions

Statistical functions aggregate data that returns a scalar value. Usually these functions operate on all the rows of the table that contain 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 column. The ‘X’ suffix identifies functions that allow you to aggregate the result of an expression applied to each ...