DAX Formulas for PowerPivot: the Excel Pro's Guide to Mastering DAX.
Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: Collie, Rob (VerfasserIn)
Format: Elektronisch E-Book
Sprache:English
Veröffentlicht: Chicago Holy Macro! Books 2013
Schlagworte:
Online-Zugang:Volltext
Beschreibung:Cover; Copyright; Table of Contents; Acknowledgements; A Note on Hyperlinks; Introduction; 1- A Revolution Built on YOU; 2- What Version of PowerPivot Should You Use?; 3- Learning PowerPivot "The Excel Way"; 4- Loading Data Into PowerPivot; 5- Intro to Calculated Columns; 6- Introduction to DAX Measures; 7- The "Golden Rules" of DAX Measures; 8- CALCULATE() -- Your New Favorite Function; 9- ALL() -- The "Remove a Filter" Function; 10- Thinking in Multiple Tables; 11- "Intermission" -- Taking Stock of Your New Powers; 12- Disconnected Tables
13- Introducing the FILTER() Function, and Disconnected Tables Continued14- Introduction to Time Intelligence; 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun; 16- SUMX() and Other X ("Iterator") Functions; 17- Multiple Data Tables; 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER(); 19- Performance: How to keep things running fast; 20- Advanced Calculated Columns; 21- The Final Transformation: One Click That Will Change Your Life Forever; A1- Further Proof That the Game is Changing; A2- So Much Power, So Little Space: Further Capabilities
A3- Four Common Error MessagesA4- Supporting Workbooks and Data Sets; A5- People: The Most Powerful Feature of PowerPivot; Index
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world's foremost PowerPivot blogger and practitioner, the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in
Beschreibung:1 Online-Ressource (256 pages)
ISBN:9781615472123
1615472126
9781615473328
1615473327

Es ist kein Print-Exemplar vorhanden.

Fernleihe Bestellen Achtung: Nicht im THWS-Bestand! Volltext öffnen