Topic: Optimization
-
Optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Watch now
-
Overview of the techniques and the tools (free and commercial) available to optimize the performance of DAX expressions in Power BI models. You learn what you can do with Performance Analyzer included in Power BI, how to extract query plans… Watch now
-
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
-
Analyze the performance of different DAX techniques to identify any products without sales in an area or a time period. Watch now
-
GROUPBY and SUMMARIZE seem similar, but they differ in both performance and functionalities. Choose the right one depending on specific scenarios! Watch now
-
Optimize the query performance of a SWITCH function in DAX that reads a slicer selection: the Group By Columns property can solve a practical problem. Watch now
-
Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this video, we introduce this optimization with some examples. Watch now
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Watch now
-
Learn why you should use ADDCOLUMNS in DAX to compute aggregations instead of doing that inside SUMMARIZE: performance can be very different! Watch now
-
In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution). This video describes the differences between the wholesale and retail modes in composite models. Watch now
