Topic: DAX
-
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
-
We are proud to announce the availability of our new book, Optimizing DAX. Read more
-
This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
-
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 DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. Read more
-
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. Read more
-
This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE. 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
-
Visual calculations are a new feature in DAX that aims to simplify the use of DAX for users by introducing calculations at the visual level rather than at the model level. Read more
-
This article introduces the VISUAL SHAPE clause, which defines a hierarchical structure for a table used in visual calculations. Read more
