(Livestream Replay) Practical Use Cases for DAX Calculated Columns - Tristan Malherbe

DESCRIPTION 📄

Over the last few years, many debates arose in the Power BI community about the use of DAX Calculated Columns. In this session, Tristan Malherbe will show concrete & real-life use cases to illustrate the power of DAX Calculated Columns. The main topics covered will be:

• Context Evaluation (Filter context, Row Context, Context Transition)

• Static Segmentation based on DAX measures
  Pre-Computing flags in Dimension tables to boost your Power BI reports' performance and ease your DAX calculations

• Inter-table calculations

• Inter-row calculations and windowing patterns with the new DAX windowing functions

GUEST BIO (Triastan Malherbe)👤

Tristan Malherbe is a Microsoft Data Platform MVP since 2017. He is the creator and current co-leader of the French Power BI User Group (Club Power BI, 7,000+ members) and more recently the French Fabric User Group (Club Fabric, 300+ members). Over the last 7 years, Tristan gave 150+ Power BI conferences & trainings in America, Europe and Middle-East. His favorite topics are Data Architecture, Data Modelling/DAX & performance tuning. Tristan is also the co-founder of Data Pulse, a Fabric & Power BI consulting firm (14 people) based in France.

RELATED CONTENT 🔗

PBIX Link
Twitter
LinkedIn
YouTube
MVP Profile

(Livestream Replay) [DAX] Best Practices 101 for Optimization & Performance - with Alberto Ferrari

ABSTRACT 📄

Despite being usually very fast, DAX can be optimized, like any other computer system. Optimizing DAX requires a deeper understanding of the internals of the engine, because most optimizations are not intuitive. We will talk about the basics of optimizations, looking at some examples of code and discussing together ideas and options to make the code faster.

GUEST BIO 👤

Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.

Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.

Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.

Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses.

Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.

RELATED CONTENT 🔗

SQLBI Website

Building Your First Calendar Table in Power BI!

Video by: Reid Havens

Get a complete step-by-step guide to building out a dedicated calendar table and independent date hierarchy (using DAX) in Power BI. Tune in to learn more!

RELATED CONTENT 🔗

Date Hierarchy Types
DAX Vs. Power Query Date Table
Power Query Dynamic Date Range

Dynamic "Column" Headers for Time Periods in Power BI

Video by: Reid Havens

Learn how to leverage DAX Calculated Columns to create dynamic time period names - that can then be used in the columns well of a matrix table to create dynamic column header names.