We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
    Page 15 of 196 articles
article –

Parameters in DAX Measures

DAX is a functional language that does not allow you to create functions. However, if you need to pass a parameter to an algorithm, you can use a measure passing a value through a filter argument in CALCULATE, as described…  Read more

article –

Choosing the Right Hardware for Analysis Services Tabular

Choosing the right hardware is critical for a solution based on Analysis Services Tabular. Spending more does not always mean having a better machine. This short article describes how to choose the right server and, as you will see, the…  Read more

article –

Variables in DAX

In this article, you learn a new feature in DAX 2015: variables. The 2015 version of the DAX language has many new functions, but none of them is a game changer for the language as variables are.  Read more

From SQL to DAX –

From SQL to DAX: IN and EXISTS

The SQL functions IN and EXISTS are useful to implement tests over a set of values. This article describes the corresponding syntax in DAX language.  Read more

article –


You might have used FIRSTNONBLANK and LASTNONBLANK in semi-additive measures, but you might not be aware that their use is not limited to time intelligence functions. This article shows alternative scenarios where these functions are useful.  Read more

article –

Custom Year-Over-Year Calculation in DAX

This article describes how to implement a custom year-over-year calculation in DAX based on arbitrary associations between different periods. As an example, we describe the comparison of the 53rd week in a ISO Calendar.  Read more

article –

All the secrets of SUMMARIZE

SUMMARIZE is a function that looks quite simple, but its functionality hides some secrets that might surprise even seasoned DAX coders. In this article, we analyze the behavior of SUMMARIZE, in order to completely describe its semantic. The final advice…  Read more