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

This article shows how to improve line charts with a date-based X-Axis in Power BI using DAX, and how to make correct choices in the data modeling and visualization properties.  Read more

In budgeting reports, a common requirement is to show future sales forecast and actual sales volume on the same line chart. This article describes how to achieve this goal using DAX.  Read more

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

This article describes the behavior of auto-exist in DAX, explaining the side effects of combining slicers on columns of the same table in Power BI.  Read more

Estimating the cardinality of iterators is an important skill when optimizing DAX code. This article explains how to use this technique, evaluating different ways of computing the number of working days between two dates.  Read more

DAX Studio connects to a Power BI Desktop model using a technique that was not officially supported until a few months ago. This changed when the “diagnostic port” was documented in this article of the official documentation:  Read more

The Sort By Column feature in Power BI causes side effects that are important to know when writing a DAX formula. This article explains these side effects and how to write correct DAX code to avoid getting incorrect results.  Read more

This article describes how to use a measure to filter a Power BI visualization, and the different behaviors of a same filter between different visuals.  Read more

In the last few years, the Business Intelligence (BI) world has been moving towards self-service BI. As expected, several vendors created tools empowering regular users to gain insights from their data. Among the many, there is Power BI. Nowadays, users…  Read more