This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. 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
This article describes possible optimization approaches to improve the performance of nested iterators in DAX. Read more
