Tools for DAX and Tabular Developers

This page contains descriptions and links to necessary tools and resources for DAX and Tabular developers.


SSAS Tabular as Analytical Engine


This article describes pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it.

DIVIDE Performance

DIVIDE Performance 01

The DIVIDE function in DAX is usually faster to avoid division-by-zero errors than the simple division operator. However, there are exceptions to this rule, described in this article through a simple performance analysis.


Using Tabular Models in a Large-scale Commercial Solution


Analysis Services Tabular can be used in large-scale solutions and SQLBI already helped several companies in the challenging effort of defining a reliable and scalable architecture, designing the right data model and optimizing the queries. One of these stories is now a case study published as a Microsoft White Paper.

Last Process Date in SSAS Tabular

How do you get the last process date for an SSAS Tabular Database? This article shows the techniques you can use and explains how to interpret the information available.

USERELATIONSHIP in Calculated Columns


In a Power Pivot or Tabular model that has inactive relationships, you can use the USERELATIONSHIP function to apply an inactive relationship to a particular DAX expression. Its usage is simple in a measure, but you might consider alternative syntax in a calculated columns, as it is explained in this

Handling Wrong or Missing Dates in Tabular

Missing Year

In the traditional star schema design of a Data Mart, you replace a missing, unknown or wrong date in the fact table with a dummy value in the Date dimension table. In Tabular, handling a Date table requires an existing date and you cannot use a NULL date in a

Grouping Transactions by Age of Customers in DAX


Grouping transactions by customers’ age requires a computation made row by row at transaction level. DAX offers an elegant solution using calculated columns, which is described in this article.

Import Data from Tabular Model in Excel Using a DAX Query


When you use Excel to connect to a Tabular database in Analysis Services, you get a PivotTable as a result. In this article, you learn how to import data in a table writing a DAX query than runs on Analysis Services.

Parallelize ProcessAdd with AMO

In this article we see a function to enable parallelism in commands sent to Analysis Services by using the AMO library even when you need to use the change the QueryBinding. This function is useful because the current AMO library (up to SQL Server 2012) cannot correctly generate the required