Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Optimizing duplicated DAX expressions using variables

SQLBI
120K subscribers
13K views 4 years ago
This video describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression. There are two related articles and downloads: https://sql.bi/62887/?aff=yt (Optimizing duplicated DAX expressions using variables) https://sql.bi/67786/?aff=yt (Optimizing IF conditions by using variables) If you are new to variables, watch this video first - it explains how the evaluation of a variable works:    • Evaluation of variables in DAX   How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... Optimizing DAX video course: https://www.sqlbi.com/p/optimizing-da... ...more
...more
Optimizing duplicated DAX expressions using variables
362Likes
13,077Views
2021Jan 7
This video describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression. There are two related articles and downloads: https://sql.bi/62887/?aff=yt (Optimizing duplicated DAX expressions using variables) https://sql.bi/67786/?aff=yt (Optimizing IF conditions by using variables) If you are new to variables, watch this video first - it explains how the evaluation of a variable works:    • Evaluation of variables in DAX   How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... Optimizing DAX video course: https://www.sqlbi.com/p/optimizing-da...

Follow along using the transcript.

SQLBI

120K subscribers