Data Analysis Expressions (DAX) is the standard PowerPivot formula language that supports custom calculations in PowerPivot tables and Excel PivotTables. While many of the functions used in Excel are included, DAX also offers additional functions for carrying out dynamic aggregation and other operations with your data. Bill's new series serves as a progressive introduction to PowerPivot and DAX formulas, examining the functions, operators and values involved, and offering a wealth of practical examples.

Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX

Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment.  Read more...

By Bill Pearson 2011/12/21 | Source: SQLServerCentral.com | Category: stairway series

Rating: |  Discuss |   Briefcase | 8,629 reads

Stairway to PowerPivot and DAX - Level 2: The DAX COUNTROWS() and FILTER() Functions

Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series.  Read more...

By Bill Pearson 2012/12/07 | Source: SQLServerCentral.com | Category: stairway series

Rating: |  Discuss |   Briefcase | 4,103 reads

Stairway to PowerPivot and DAX - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts

Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot and DAX series.  Read more...

By Bill Pearson 2013/02/26 | Source: SQLServerCentral.com | Category: stairway series

Rating: |  Discuss |   Briefcase | 3,385 reads

Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function

Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs.  Read more...

By Bill Pearson 2013/03/18 | Source: SQLServerCentral.com | Category: stairway series

Rating: |  Discuss |   Briefcase | 2,888 reads

Stairway to PowerPivot and DAX - Level 5: The DAX ISBLANK() Function

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX ISBLANK() function, and then provides some hands-on exposure to its use, particularly in combination with other DAX functions, in managing empty values underlying our PowerPivot model designs.  Read more...

By Bill Pearson 2013/05/09 | Source: SQLServerCentral.com | Category: stairway series

Rating: |  Discuss |   Briefcase | 2,246 reads