Practical Powerpivot Dax Formulas For Excel 2010

Download or read book Practical Powerpivot & Dax Formulas For Excel 2010 written by Art Tennick and published by Tata McGraw-Hill Education. This book was released on 2010-10-10 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: take advantage of DAX (Data Analysis Expressions) the new standard language for extracting BIwithin the familiar environment of Excel.This solutions-based guide contains more than 200 DAX queries that can be immediately appliedacross a wide variety of BI-related problems. It begins with fundamental principles and simplequeries and rapidly progresses to complex and sophisticated queries. The book is structured asfollows:* Query: Introduction and description of query and its use* Syntax: Complete DAX syntax* Result: Screen shot showing the data returned in an Excel 2010 pivot table* Analysis: Analysis of the results and tips for customization