(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) Fabric & Power BI: Awesome Use-Cases with DAX Query View - with Zoe Douglas

DESCRIPTION 📄

Join us live as we dive into the world of Microsoft Fabric! In this session, Zoe will walk you through the process of creating semantic models using three powerful approaches: Direct Lake, Import, and DirectQuery (DQ). We'll explore how each of these methods can be utilized within Microsoft Fabric to build robust and scalable models tailored to your data needs.

But that's not all—once we've crafted these models, I'll demonstrate how you can leverage them to write efficient DAX queries using the DAX Query View. Whether you're new to Microsoft Fabric or looking to refine your skills, this demo will provide valuable insights and practical techniques you can apply to your projects.

Bring your questions and curiosity, and let's explore the possibilities together!

GUEST BIO (Zoey Douglas)👤

Zoe is a Product Manager at Microsoft working on Power BI in Microsoft Fabric with features such as DAX query view, Direct Lake, Model Explorer, and Copilot. Before coming to Microsoft I was a Power BI consultant and mentor, enjoying the Power BI community forum and taking on data challenges.

RELATED CONTENT 🔗

Direct Lake
DAX Query View
Web Modeling
Model Explorer

Dynamic Rank Conditional Formatting for Tables in Power BI

Video by: Reid Havens

Learn how to leverage What If Parameters to apply dynamic conditional formatting to values on tables or matrix visuals in Power BI Desktop. Tune in to learn more!

Conditional Formatting Integrated Bar Upgrades!

Video by: Reid Havens

Learn how to combine some DAX modeling design + conditional formatting data bars to unify values between the min/max bar sizes. Tune in to learn more!