Topic: DAX
-
How to implement the comparison between school terms. The same technique can be applied to any arbitrary time periods that do not match regular months or quarters in a calendar, such as seasons or campaigns. Watch now
-
Choose between many-to-many relationships and DAX code to filter the most relevant items using another slicer. Indeed, calculation groups cannot use relationships! Watch now
-
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
-
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
-
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