Topic: DAX
-
Student question: how to display only child values in a parent-child hierarchy, ignoring aggregations? Watch the solution implemented step-by-step! 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
-
How to implement a DAX measure to run faster than what you get from the built-in horizontal fusion optimization. Watch now
-
How can we show a row with the initial balance in a Power BI report? Another video that answers a student's question! Watch now
-
This video introduces the syntax and functionalities of the new DAX window functions: INDEX, OFFSET, and WINDOW. Watch now
-
Every Power BI model has dates and the need for calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and standard time intelligence functions in DAX can help, but how do… Watch now
-
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
-
Learn how to debug a DAX measure that returns an incorrect result by using different techniques, with and without external tools. 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
