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

Start Free Trial

No credit card required