Microsoft Download Center Archive

DAX in the BI Tabular Model Whitepaper and Samples

  • Published:
  • Version: 1.0
  • Category: SDK
  • Language: English

This whitepaper and sample workbook introduce Data Analysis Expressions (DAX), a formula expression language used to define calculations in PowerPivot for Excel® workbooks and Analysis Services tabular model projects authored in SQL Server Data Tools.

  • This DAX in the BI Tabular Model file contains two files:

    • Contoso Sample DAX Formulas.xlsx PowerPivot for Excel workbook
    • DAX in the BI Tabular Model.docx whitepaper

    • The PowerPivot workbook illustrates the data analysis expressions (DAX) discussed in the included whitepaper.


    The Contoso DAX Formula Samples file contains one file:
    • Contoso Sample DAX Formulas.xlsx PowerPivot for Excel workbook


    NOTE: To fully interact with this sample, you must have Microsoft Excel 2010 and the Microsoft PowerPivot for Excel add-in installed or SQL Server 2012 Analysis Services instance running in Tabular mode and Visual Studio 2010 with SQL Server Data Tools installed.

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

FileSize
Contoso DAX Formula Samples.zip
SHA1: 9b6b80728a0039986c8d5d63b9461519773ca998
159.58 MB
DAX in the BI Tabular Model.zip
SHA1: 2f1710694a65e41dd89c3c2e057205ebca6ab3e0
162.96 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows 7, Windows Server 2003 R2 (32-Bit x86), Windows Server 2003 R2 x64 editions, Windows Server 2008 R2, Windows Vista Service Pack 2, Windows XP Service Pack 3

  • Windows 7
    Windows Server 2008 R2 (64-bit)
    Windows XP with SP3 (32-bit)
    Windows Vista with SP2 (32-bit or 64-bit)*
    Windows Server 2008 with SP2 (32-bit or 64-bit)*
    Windows Server 2003 R2 (32-bit or 64-bit) with MSXML 6.0 installed+
    Terminal Server and windows on Windows (WOW)-- which allow you to instal 32-bit versions of Office 2010 on 64-bit operating system-- are supported.

Installation Instructions

  • 1. Download and save these samples to a folder on your local computer.
    2. Start Excel 2010.
    3. On the File menu, click Open.
    4. Open the sample file that you want to view.
    5. To view the data embedded in the workbook, click PowerPivot Window Launch on the PowerPivot tab.