Topic: DAX
-
How to apply dynamic security roles in a hierarchical organization to minimize the maintenance effort on the security configuration and obtain the best performance at query time. Watch now
-
GROUPBY and SUMMARIZE seem similar, but they differ in both performance and functionalities. Choose the right one depending on specific scenarios! Watch now
-
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
-
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
