Data Analysis eXpressions (DAX) includes more powerful functions for BI type data manipulations, including iterative expressions, grouping, linking, and filtering. The full promise of PowerPivot is ...

PowerPivot is Microsoft's new self-service business intelligence (BI) product that seeks to make peace between IT and Excel users. PowerPivot is a component of SQL Server 2008 R2 that works with Excel ...

Note that DAX isn’t a substitute for the old formula language, but a complement to it; odds are you’ll still be using all of your existing Excel macro tricks in conjunction with PowerPivot.

Become an Excel —and Google Sheets—master by studying with this $35 course pack.