O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

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

Chapter 11Math & Trig Functions

This is the final chapter dealing with DAX functions and formulas. It deals with the Math & Trig functions. However, you won’t find any trigonometric functions as such—expect these to appear in a later version of PowerPivot for Excel. Some of the functions, for example, EXP() and LN(), are probably for specialized use only. However, many of the others are going to be very popular—particularly, the eight functions devoted to rounding numbers. SUM() and SUMX() are Math & Trig functions, although they have much in common with the Statistical functions as well. They were both covered in an earlier chapter on aggregate functions (that is, Statistical functions with SUM() and SUMX()), but are mentioned here again for ...

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