Independent Publishers Group Logo

Sign up today...
for featured titles, special offers, bestsellers, and more, in your inbox!

Subscribe to receive special offers, monthly books suggestions, seasonal selections, and more!

Close
PowerPivot for Excel
PowerPivot for Excel

PowerPivot for Excel

Commonly Used Functions and Technique

COMPUTERS

2 Pages, 8.5 x 11

Trade Paper, $2.95 (US $2.95) (CA $2.95)

Publication Date: April 2013

ISBN 9781615479993

Rights: WOR

Holy Macro! Books (Apr 2013)

Sorry, this item is temporarily out of stock
 

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.