Sign in  |  Register
Advanced search
Publication Cover

CITATION

Tennick, Art. Practical PowerPivot & DAX Formulas for Excel 2010. US: McGraw-Hill Osborne Media, 2010.

Practical PowerPivot & DAX Formulas for Excel 2010

Authors: Art Tennick

Published:  August 2010

eISBN: 9780071746861 0071746862 | ISBN: 9780071746854
Open eBook
  • Contents
  • Foreword
  • Acknowledgments
  • Introduction
  • Part I: PowerPivot
  • Chapter 1 PowerPivot: Quick Start
  • Chapter 2 PowerPivot: Overview
  • Starting PowerPivot
  • Importing from SQL Server
  • Importing from Access
  • Importing from Excel
  • Importing from a Data Feed
  • PowerPivot Window
  • Checking Relationships
  • Adding Columns
  • A Quick Pivot Table
  • A Very Quick Pivot Chart
  • Chapter 3 PowerPivot: In-Depth
  • PowerPivot Ribbon in Excel
  • Home Ribbon in PowerPivot
  • Design Ribbon in PowerPivot
  • Linked Table Ribbon in PowerPivot
  • Chapter 4 DAX: Overview
  • What Is DAX?
  • Where to Write DAX
  • How to Write DAX
  • Why Use the RELATED() Function?
  • Why Use the CALCULATE() Function?
  • Where to Go from Here
  • Chapter 5 Pivot Tables and Pivot Charts: Overview
  • Background to Pivot Reports
  • Pivot Tables
  • Pivot Charts
  • Part II: DAX
  • Chapter 6 Fundamental Functions: Filter, Logical, and Miscellaneous Functions
  • ALL() 1/7
  • ALL() 2/7
  • ALL() 3/7
  • ALL() 4/7
  • ALL() 5/7
  • ALL() 6/7
  • ALL() 7/7
  • ALLEXCEPT() 1/2
  • ALLEXCEPT() 2/2
  • ALLNOBLANKROW()
  • AND()
  • BLANK()
  • CALCULATE()
  • CALCULATETABLE()
  • DISTINCT()
  • EARLIER()
  • EARLIEST()
  • FALSE()
  • FILTER()
  • IF()
  • IFERROR()
  • ISBLANK()
  • ISERROR()
  • ISLOGICAL()
  • ISNONTEXT()
  • ISNUMBER()
  • ISTEXT()
  • NOT()
  • OR()
  • RELATED()
  • RELATEDTABLE()
  • TRUE()
  • VALUES()
  • Chapter 7 Aggregate Functions: Statistical Functions and SUM()/SUMX() Functions
  • AVERAGE()
  • AVERAGEX()
  • AVERAGEA()
  • COUNT()
  • COUNTX()
  • COUNTA()
  • COUNTAX()
  • COUNTBLANK()
  • COUNTROWS()
  • MAX()
  • MAXX()
  • MAXA()
  • MIN()
  • MINX()
  • MINA()
  • SUM() 1/2
  • SUM() 2/2
  • SUMX()
  • Chapter 8 Date & Time Functions 1/2: Basic Functions
  • DATE()
  • DATEVALUE()
  • DAY()
  • EDATE()
  • EOMONTH()
  • HOUR()
  • MINUTE()
  • MONTH()
  • NOW()
  • There Is No QUARTER()
  • SECOND()
  • TIME()
  • TIMEVALUE()
  • TODAY()
  • WEEKDAY()
  • WEEKNUM()
  • YEAR()
  • YEARFRAC()
  • Chapter 9 Date & Time Functions 2/2: Time Intelligence Functions
  • CLOSINGBALANCEMONTH()
  • CLOSINGBALANCEQUARTER()
  • CLOSINGBALANCEYEAR()
  • DATEADD()
  • DATESBETWEEN()
  • DATESINPERIOD()
  • DATESMTD()
  • DATESQTD()
  • DATESYTD()
  • ENDOFMONTH()
  • ENDOFQUARTER()
  • ENDOFYEAR()
  • FIRSTDATE()
  • FIRSTNONBLANK()
  • LASTDATE()
  • LASTNONBLANK()
  • NEXTDAY()
  • NEXTMONTH()
  • NEXTQUARTER()
  • NEXTYEAR()
  • OPENINGBALANCEMONTH()
  • OPENINGBALANCEQUARTER()
  • OPENINGBALANCEYEAR()
  • PARALLELPERIOD()
  • PREVIOUSDAY()
  • PREVIOUSMONTH()
  • PREVIOUSQUARTER()
  • PREVIOUSYEAR()
  • SAMEPERIODLASTYEAR()
  • STARTOFMONTH()
  • STARTOFQUARTER()
  • STARTOFYEAR()
  • TOTALMTD()
  • TOTALQTD()
  • TOTALYTD()
  • Chapter 10 Text Functions
  • CONCATENATE() 1/2
  • CONCATENATE() 2/2
  • EXACT()
  • FIND()
  • FIXED()
  • FORMAT()
  • LEFT()
  • LEN()
  • LOWER()
  • MID()
  • REPLACE()
  • REPT()
  • RIGHT()
  • SEARCH()
  • SUBSTITUTE()
  • TRIM()
  • UPPER()
  • VALUE()
  • Chapter 11 Math & Trig Functions
  • ABS()
  • CEILING()
  • EXP()
  • FACT()
  • FLOOR()
  • INT()
  • ISO.CEILING()
  • LN()
  • LOG()
  • LOG10()
  • MOD()
  • MROUND()
  • PI()
  • POWER()
  • QUOTIENT()
  • RAND()
  • RANDBETWEEN()
  • ROUND()
  • ROUNDDOWN()
  • ROUNDUP()
  • SIGN()
  • SQRT()
  • SUM()
  • SUMX()
  • TRUNC()
  • Part III: PowerPivot and DAX Applied
  • Chapter 12 A Few Ideas: PowerPivot and DAX Solutions
  • Do You Have a Problem on Dates?
  • Numbers That Don't Add Up
  • Classic BI Solutions
  • Predefining Filters and Sets
  • PowerPivot Without Pivot Table Data
  • Self-Joins
  • Data Mining
  • SSRS
  • SharePoint
  • Is It Really a Cube?
  • How Old Is Nancy?
  • Part IV: Appendixes: Queries for PowerPivot
  • Appendix A: SQL Queries for PowerPivot
  • Why Write SQL Queries?
  • Where to Create and Test SQL Queries
  • Where to Use SQL Queries in PowerPivot
  • SQL Examples
  • SQL Queries for Excel
  • Appendix B: MDX Queries for PowerPivot
  • Why Write MDX Queries?
  • Where to Create and Test MDX Queries
  • Where to Use MDX Queries in PowerPivot
  • MDX Examples
  • Appendix C: DMX Queries for PowerPivot
  • Why Write DMX Queries?
  • Where to Create and Test DMX Queries
  • Where to Use DMX Queries in PowerPivot
  • DMX Examples
  • Index