Topic: DAX
-
Student questions: How to compute the sales amount of the previous date with a filter over weekdays? Learn why a filter below the month level may affect any time intelligence calculation! Watch now
-
Introduction to dynamic format strings feature released in Power BI May 2023, including a few technical details of its implementation. Watch now
-
Different rounding differences can appear in DAX depending on data types and operations performed: knowing these details helps you write more robust DAX formulas and avoid comparison errors. 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
-
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
