Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Prepare for the Power BI Data Analyst Associate (PL-300) exam in this course, with topics pertaining to creating model calculations using DAX.

Introduction

• Model the data in the PL-300 exam
• Before you begin
• Creating model calculations with DAX
• Model design best practices
• Power BI Desktop and the exercise files

1. Tables and Relationships

• Working with Tables: Best practices
• One-to-one relationships
• One-to-many relationships
• Many-to-many relationships
• Common pitfalls in creating relationships

2. Functions

• Recap of functions
• Row and filter contexts
• Using the CALCULATE function
• Creating dates with CALENDAR and CALENDARAUTO
• Accessing related data with the RELATED function
• Overriding default relationships with functions
• Time-intelligence functions
• Statistical functions

3. Measures

• Demo: Creating a quick measure in Power BI
• Demo: Creating a full measure
• Demo: Semi-additive measures
• Calculated columns vs. measures
• Implicit vs. explicit measures
• Work with aggregations
• Demo: Calculated tables

Conclusion

• Next steps