250 posts
article –

# Computing the future value of an investment based on compound growth in DAX

This article describes how to write efficient DAX expressions that compute the compound interest of incremental investments made throughout the holding period, using the PRODUCTX function.  Read more

article –

# Understanding eager vs. strict evaluation in DAX

This article describes the differences between eager evaluation and strict evaluation in DAX, empowering you to choose the best evaluation type for your data models.  Read more

article –

# Optimizing conditions involving blank values in DAX

This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases.  Read more

article –

article –

# Analyzing the performance of DISTINCTCOUNT in DAX

This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations.  Read more

blog post –

# The Definitive Guide to DAX second edition now available worldwide

The second edition of The Definitive Guide to DAX is now available worldwide! This blog post explains why we felt the need to rewrite the book and describes what happens behind the scenes when producing a book.  Read more

article –

Values such as inventory and account balance, usually calculated from a snapshot table, require the use of semi-additive measures. This article describes how to implement these calculations in DAX according to your specific requirements.  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

blog post –

# Power Pivot Utilities 1.09

Bertrand d’Arbonneau added a new feature in the last version (v 1.09) of Power Pivot Utilities, which allows the visualization of Dependents and Precedents measures in the measure list created by the List Measures tool. How to use the new…  Read more

article –

# Optimizing duplicated DAX expressions using variables

This article describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression.  Read more