In his book author Art Tennick provides a comprehensive guide for extracting actionable insights from massive corporate datasets. This "hands-on" resource is particularly noted for:

RANKX : Automatically ranks items (like products or sales reps) based on a specific value. Practical PowerPivot & DAX Formulas for Excel 2010

: Practical examples show how to compare current performance against the past and handle tricky calculations like running totals or non-numeric values.