Mastering UDFs & Custom Calendars in Power BI: Latest Features & Best Practices

Explore the cutting-edge enhancements in Power BI with Jeroen ter Heerdt as he dives into User Defined Functions (UDFs) and custom calendars. This D&C User Group session is packed with demos, expert insights, and practical examples to help BI developers—from beginners to pros—leverage these powerful new features.

🔍 Learn how to define reusable logic in DAX, implement flexible currency conversion functions, and build custom time intelligence models using tailored calendar configurations. Plus, discover how these tools boost performance and enable more accurate reporting across different fiscal calendars.

💬 Don't miss the rich Q&A throughout the session where common use cases, error handling, SVG visualizations, and data model strategies are covered.



00:00 Introduction
03:58 What Are DAX User Defined Functions (UDFs)?
06:22 Writing Your First UDF – Syntax and Testing
22:42 Real-World Use Case: Currency Conversion Function
31:58 SVG and Visualisation Use with UDFs
32:09 Power BI Custom Calendars: A New Way to Handle Time Intelligence
46:56 Week-to-Date and Calendar Validation in DAX
58:03 Advanced Calendar Use Cases and Time-Related Columns

https://learn.microsoft.com/en-us/dax...
https://www.sqlbi.com/topics/user-def...
https://docs.tabulareditor.com/te3/tu...
https://daxlib.org/packages/
  / top-20-dax-user-defined-functions-real-wor...  
   • Power BI + SVG: How to Build Custom Visual...  
https://icon-map.com/blog/telecoms-ce...
https://learn.microsoft.com/en-us/dax...
   • The Magic Combo: DAX UDFs + Calculation Gr...  
https://tabulareditor.com/learn
https://www.sqlbi.com/articles/introd...
https://learn.microsoft.com/en-us/pow...
   • Speed Up Your Power BI Time Intelligence -...  
https://evaluationcontext.github.io/p...