Topic: DAX

        327 posts
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

article –

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

blog post –

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

blog post –

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