Posts filed under DAX

(Livestream Replay) DAX Query View Testing Patterns - with John Kerski

DESCRIPTION πŸ“„

Are you struggling with managing issues in your semantic models/datasets? Would you like to conduct tests and easily share those tests with your team? In this session I show you a DAX Query View Testing Pattern. This pattern combines the new DAX Query View feature in Power BI Desktop and DataOps principles to help you improve project delivery and reduce errors.

GUEST BIO πŸ‘€

John leverages his 10+ years of technical and government leadership experience to help Federal Agencies, and private sector clients utilize Microsoft products to their fullest potential. His certifications with Microsoft products offers customers a high rate of return when looking to invest in Microsoft solutions.

RELATED CONTENT πŸ”—

Blog
LinkedIn

Posted on September 23, 2024 and filed under Livestreams, DAX.

(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

Posted on September 13, 2024 and filed under Livestreams, DAX.

(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

Posted on September 6, 2024 and filed under Livestreams, DAX, Fabric, Data Modeling, Power BI Service.