Topic: DAX
-
The different results of DATEADD and PARALLELPERIOD in DAX may impact many other time intelligence functions that are syntax sugar of these two. Watch now
-
Avoid circular dependencies when calculated columns or tables are involved in regular one-to-many relationships. Related articles: https://www.sqlbi.com/articles/blank-row-in-dax/ https://www.sqlbi.com/articles/expanded-tables-in-dax/ Watch now
-
Discover the new DAX Query View introduced in Power BI Desktop November 2023. Spoiler: it is a good feature! Watch now
-
How to apply conditional formatting on measures picked from a slicer and implemented using two techniques: field parameters and calculation groups. Watch now
-
Analyze the performance of different DAX techniques to identify any products without sales in an area or a time period. Watch now
-
Ho to use DAX expressions to control and customize the range of charts in Power BI. Watch now
-
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
