Topic: DAX
-
This session introduces the Visual Calculations feature in Power BI, which provides a different way to write DAX expressions based on the results visible in a visual and without accessing other information in the semantic model. Because the data in… Watch now
-
Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used. Delivered by Marco Russo at SQLBits 2024. Watch now
-
Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations. Sessions delivered by Marco Russo at SQLBits 2024. Watch now
-
Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance. Delivered by Marco Russo at SQLBits 2024. Watch now
-
Learn how to use the new Vpax obfuscator to send anonymized VPAX files to DAX Optimizer. Read more: https://www.tabulartools.com/blog/supporting-obfuscation-in-dax-optimizer/ Disclaimer of a potential conflict of interest: Marco Russo is one of the authors of DAX Optimizer and a founder of… Watch now
-
Another student’s question, another video: how to count how many consecutive days have sales? See how to solve the problem step-by-step! Watch now
-
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