Improving temporal line charts in Power BI with DAX
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
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
Understanding DAX Auto-Exist
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
DAX Guide – the reference I had been wanting
If you have read the book Alberto and I wrote, “The Definitive Guide to DAX” then by looking at the title you might think that this post is about the book. Not this time. I am talking about the new… Read more
Optimizing DAX with cardinality estimation: computing working days
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
Optimizing nested iterators in DAX
This article describes possible optimization approaches to improve the performance of nested iterators in DAX. Read more
DAX Studio and Power BI diagnostic port
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
Dates differences between Excel and DAX
DAX supports dates starting in 1900 and while teaching DAX I always explain that DAX manages dates like Excel, which is the reason why these limitations exist. Actually, this is true – but answering to a comment today I realized… Read more
Side effects of the Sort By Column setting in DAX
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
Power BI DAX optimization examples
How can you optimize your DAX expressions? In this session, we’ll analyze DAX expressions and Tabular models, then utilize DAX Studio and the VertiPaq model to explore how to optimize them. While most optimizations are the direct application of best… Watch now