Learn DAX in Toronto!

SSAS

ARTICLE

Calculated Columns and Measures in DAX

ColumnsMeasures-02

One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recap the differences and describes when to use each one.

ARTICLE

Data Model Size with VertiPaq Analyzer

DMV Size 01

Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views.

ARTICLE

Tools for DAX and Tabular Developers

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

WHITEPAPER

SSAS Tabular as Analytical Engine

sass-as-engine@2x

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.

ARTICLE

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.

WHITEPAPER

Using Tabular Models in a Large-scale Commercial Solution

large-scale

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.

ARTICLE

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.

ARTICLE

USERELATIONSHIP in Calculated Columns

MultipleRelationships

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

ARTICLE

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

ARTICLE

Grouping Transactions by Age of Customers in DAX

GroupByAge-Fig01

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.