Overview
Demystifying the often confusing and muddled logic of DAX Formula Language, this tip shows concrete examples of working DAX formulas, allowing readers to expand and build upon their existing knowledge and produce new kinds of reports and analyses that were simply impossible before. Topics addressed include commonly used functions and techniques, time intelligence with custom calendar, 30 day moving range, and suppressing subtotals and grand totals.Author Biography
Rob Collie is chief technology officer at Pivotstream LLC, where he and other Excel pros utilize PowerPivot to provide actionable business information to dozens of Fortune 500 corporations. He spent 13 years at Microsoft where he led teams of software engineers on projects including PowerPivot v1, multiple versions of Excel, Windows Installer (MSI) v1, the Bing search engine, and MSN Fantasy Sports. He is also the world’s most prolific PowerPivot blogger, running the PowerPivotPro.com and PowerPivotFAQ.com websites since late 2009. He is the author of DAX Formulas for PowerPivot. He lives in Cleveland Heights, Ohio.