## DIVIDE Performance

The DIVIDE function in DAX is usually faster to avoid division-by-zero errors than the simple division operator. However, there are… Read More »

## Rolling 12 Months Average in DAX

Computing the rolling 12-month average in DAX looks like a simple task, but it hides some complexity. This article explains… Read More »

## 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… Read More »

## Check Empty Table Condition with DAX

In DAX there are different ways to test whether a table is empty. This test can be used in complex… Read More »

## FILTER vs CALCULATETABLE: optimization using cardinality estimation

A common best practice is to use CALCULATETABLE instead of FILTER for performance reason. This article explore the reasons of… Read More »

## 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… Read More »

## Natural Hierarchies in Power Pivot and Tabular

Creating a hierarchy in a Power Pivot or Tabular data model is very easy, but you might experience performance issues… Read More »

## Understanding Distinct Count in DAX Query Plans

Distinct Count calculations in DAX are very fast compared to other engines. But when you have a large number of… Read More »

Values such as inventory and balance account, usually calculated from a snapshot table, require the use of semi-additive measures. In… Read More »

## USERELATIONSHIP in Calculated Columns

In a Power Pivot or Tabular model that has inactive relationships, you can use the USERELATIONSHIP function to apply an… Read More »

## Handling Wrong or Missing Dates in Tabular

In the traditional star schema design of a Data Mart, you replace a missing, unknown or wrong date in the… Read More »

## Yearly Customer Historical Sales in DAX

With DAX you can calculate the sales of the first, second and third year of a new customer without any… Read More »

## Inventory in Power Pivot and DAX: Snapshot vs. Dynamic Calculation

You can implement the calculation of stock inventory over time in several ways in DAX. The xVelocity technology in Power… Read More »

## Understanding DAX Query Plans

Understanding DAX query plans is a long process. This paper explains how to capture and read a DAX query plan,… Read More »

## 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… Read More »

## Week-Based Time Intelligence in DAX

The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date (YTD), year-over-year (YOY) and so… Read More »

## 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.… Read More »

## Linkback Tables in PowerPivot for Excel 2013

In PowerPivot for Excel 2010 it is possible to import an Excel table in a PowerPivot data model by using… Read More »

## Rules for DAX Code Formatting

With the modern editors that have automatic code formatting features, each one has its own code formatting style. Usually there… Read More »

## Usage of dates argument in a row context

Several Time Intelligence functions in DAX use a <dates> argument, which has a special behavior because it can be expressed… Read More »