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 ...
Get Practical PowerPivot & DAX Formulas for Excel 2010 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.
