Topic: Optimization
-
Almost a year ago, we announced the release of three sections (core concepts, formula engine, and VertiPaq); in November 2023, we released the DirectQuery over SQL section; now, in April 2024, we release the last section of Optimizing DAX about… Read more
-
Learn how to use the new Vpax obfuscator to send anonymized VPAX files to DAX Optimizer. Read more: https://www.tabulartools.com/blog/supporting-obfuscation-in-dax-optimizer/ Disclaimer of a potential conflict of interest: Marco Russo is one of the authors of DAX Optimizer and a founder of… Watch now
-
This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions. Read more
-
At SQLBI, Alberto Ferrari and I spend most of our time sharing our knowledge and expertise in DAX. We have been doing this for years, navigating through conferences, workshops, and videos, encountering many individuals – from eager beginners to seasoned… Read more
-
Writing measures referencing other measures is in general a good idea that simplifies the DAX code, but you might face specific bottlenecks. This article describes which performance issues might arise when different measures aggregate the same column using different filter… Read more
-
This article explains a typical pattern to optimize a SUMX iterator by reducing the number of callbacks in the expression. Read more
-
Analyze the performance of different DAX techniques to identify any products without sales in an area or a time period. Watch now
-
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
-
GROUPBY and SUMMARIZE seem similar, but they differ in both performance and functionalities. Choose the right one depending on specific scenarios! Watch now
-
Both GROUPBY and SUMMARIZE are useful functions to group by columns. However, they differ in both performance and functionalities. Knowing the details lets developers choose the right function for their specific scenario. Read more