Getting Started with the DAX queries for SQL Server Analysis Services

Problem

I would like to learn the DAX query language for SQL Server Analysis Services Tabular Data, is there a simple tutorial to get started?

Solution

In this tip, we will work with DAX for newbies who want to get started.

DAX means Data Analysis Expressions and it is a simpler query language than MDX. MDX or Multidimensional Data Expressions is the language used for the Analysis Services Multidimensional Databases. DAX started as a function language and an extension of Excel in Power Pivot. Now it is a query language used in Tabular Databases. Tabular Databases started in SQL Server 2008 R2 and now the functionality and popularity is increasing.

Read more...