Topic: Tabular
-
The second edition of the Optimizing DAX video course is available: new content, a new book, and some on the behind-the-scenes of the project. Read more
-
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
-
This article describes how to implement a DAX measure to run faster than what you get from the built-in fusion optimization. Read more
-
How to implement a DAX measure to run faster than what you get from the built-in horizontal fusion optimization. Watch now
-
This article provides the best practice to use ADDCOLUMNS and SUMMARIZE, two functions that can be used in any DAX expression, including measures. Read more
-
DAX Studio 3.0.6 introduces a new Timeline visualization in Server Timings to help you investigate performance issues: let’s explore how it works! Watch now
-
This article describes how Power BI uses the Group By Columns attribute of a column and how you can leverage it in specific scenarios. Read more
-
DAX provides a set of functions (Time Intelligence) to compute aggregations and comparisons over a range of dates: Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. The DAX time intelligence functions can work well with a month granularity, but they have… Watch now
-
The composite models in Power BI introduced a new type of relationship cardinality called many-to-many. Nevertheless, despite their name, they are not many-to-many relationships: they are relationships between tables generated at different granularity. In this session, we clarify the purpose… Watch now
-
A recap of the news in the DAX world in 2022 and a preview of what we expect in 2023. Happy New Year! Watch now