Practical Powerpivot & Dax Formulas For Excel 2010
Author | : Art Tennick |
Publisher | : Tata McGraw-Hill Education |
Total Pages | : 0 |
Release | : 2010-10-10 |
ISBN-10 | : 0071074171 |
ISBN-13 | : 9780071074179 |
Rating | : 4/5 (179 Downloads) |
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