Topic: DAX
-
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
-
This video introduces the syntax and functionalities of the new DAX window functions: INDEX, OFFSET, and WINDOW. Watch now
-
How can you move a filter from one table to another without a relationship in Power BI? By using the DAX code shown in this unplugged video! Watch now
-
Discover how we answer a student question requesting a variation of the like-for-like calculation, computing the sales in other stores only considering the brands sold in the selected store. Watch now
-
Learn how to debug a DAX measure that returns an incorrect result by using different techniques, with and without external tools. 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
-
This video explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool. Watch now
-
This video explains the more common errors in CALCULATE filter arguments and how to solve them. Watch now
-
Calculation groups are the most important feature introduced in DAX after variables in 2015. By using calculation groups, you can apply transformations to existing measures without having to create new measures in the model. For example, you can define the… Watch now