O'Reilly logo

Microsoft® PowerPivot for Excel® 2010 by Alberto Ferrari, Marco Russo

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

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