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.