Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag DAX Rss

   Items 1 to 20 of 24    Older >>
 

Stairway to PowerPivot and DAX - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/09/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,936 reads

Stairway to PowerPivot and DAX - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/08/27 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,468 reads

DAX Relationships

Learn how relationships work in Powerpivot workbooks and how you can build them using the DAX language.  Read more...
By Michael Carper 2014/05/29 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 2,407 reads

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 2014/05/07 (first published: 2011/12/21) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 21,260 reads

DAX: Topn is not a Filter

In this document I will demonstrate how using the TOPN function in a DAX query doesn’t necessarily do what you may expect.  Read more...
By Gary Strange 2014/05/01 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 2,941 reads

Percentile calculations in DAX

It is not always easy to do what Excel does with PERCENTILE.INC. Learn what formulas to use in this article.  Read more...
By Antonio Abalos Castillo 2014/04/28 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 2,641 reads

DAX Query - Part 2

A more detailed look at the DAX language and some of its more frequently used functions  Read more...
By Gary Strange 2013/12/13 (first published: 2013/05/02) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 7,678 reads

DAX Query Basics

In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.   Read more...
By Gary Strange 2013/12/12 (first published: 2012/09/25) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 13,909 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/12/04 (first published: 2013/05/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,108 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/11/06 (first published: 2013/03/18) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,499 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/10/09 (first published: 2013/02/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,581 reads

DAX Statistical Functions

Following on from his first four articles on using Data Analysis Expressions (DAX) with tabular databases, Robert Sheldon dives into some of the DAX statistical functions available, demonstrating which are the most useful and examples of how they work.  Read more...
By Additional Articles 2013/10/07 | Source: SimpleTalk | Category: dax
Rating:  Rate this |   Briefcase | 2,387 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 2013/09/11 (first published: 2012/12/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,010 reads

Using DAX to create SSRS reports: The Basics

You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon describes a poorly-documented but important technique for Business Intelligence.  Read more...
By Additional Articles 2013/09/09 | Source: SimpleTalk | Category: dax
Rating:  Rate this |   Briefcase | 3,399 reads

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 2014/05/07 (first published: 2011/12/21) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 21,260 reads

Using DAX to retrieve tabular data

Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window of SSMS to directly access data from a tabular SSAS database, an in-memory database that uses the xVelocity analytics engine and compression. Robert Sheldon shows how easy it is to retrieve data from a tabular database.  Read more...
By Additional Articles 2013/07/15 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,697 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/12/04 (first published: 2013/05/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,108 reads

DAX Query - Part 2

A more detailed look at the DAX language and some of its more frequently used functions  Read more...
By Gary Strange 2013/12/13 (first published: 2013/05/02) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 7,678 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/11/06 (first published: 2013/03/18) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,499 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/10/09 (first published: 2013/02/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,581 reads
   Items 1 to 20 of 24    Older >>
 
Tags
powerpivot (10)    
stairway series (8)    
analysis services (ssas) (3)    
tabular model (3)    
bi (2)    
excel (2)    
business intelligence (1)    
percentile.inc (1)    
reporting services (ssrs) (1)    
sum() (1)    
sumx() (1)    
tabular (1)