Topic: DAX

        332 posts
blog post –

Naming variables in DAX

The current version of DAX has a limitation for names you can provide to variables in a DAX expression: a variable name cannot be the name of a table in the data model. This is not a big issue if…  Read more

article –

Understanding the data lineage in DAX

Data lineage is a DAX feature so well-implemented that most developers use it without knowing about its existence. This article describes the data lineage and how it can help producing better DAX code.  Read more

blog post –

What has happened in the DAX world in 2018

We are approaching the end of 2018, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2019. New DAX…  Read more

blog post –

Displaying a list of selected months

Today I woke up with an interesting question, about how to show a selection of months in a nice way, detecting contiguous selection. You can easily understand the desired solution from the following figure: I enjoyed writing a quick solution,…  Read more

article –

Bidirectional relationships and ambiguity in DAX

Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models as numbers become unpredictable. This article provides a deep explanation of the kind of ambiguity that might appear…  Read more

article –

Understanding numeric data type conversions in DAX

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages.  Read more

article –

Displaying Nth Element in DAX

This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties.  Read more