DAX for Paginated Reports

Learn how to work with DAX inside of Power BI Paginated Reports to effectively create datasets and use parameters successfully.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

Learn how to work with DAX inside of Power BI Paginated Reports to effectively create datasets and use parameters successfully.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

In this class we will look at how to read and leverage DAX with Paginated reports. We will see the default behavior of the Analysis Services query designer and how to enhance it or even write your own DAX from scratch. As well we will see how we can use a tool like DAX Studio can help us curate our DAX statements.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

DAX for Paginated Reports - What You Need to Get Started

Module 00 - Class Introduction 7 min.

Module 01- Introduction to the Analysis Services Query Designer 17 min.

Module 02 - DAX Studio Overview 12 min.

Module 03A - Working with DAX in Paginated Reports (SUMMARIZECOLUMNS) 26 min.

Module 03B - Working with DAX in Paginated Reports (ADDCOLUMNS and SELECTCOLUMNS) 26 min.

Module 03C - Working with DAX in Paginated Reports (SELECTCOLUMNS, RELATED and SUMMARIZE) 36 min.

Module 04A - Working with Parameters (Single Value Parameters) 52 min.

Module 04B - Working with Parameters (Multi Value and Cascading Parameters) 46 min.

Module 05 - Class Outro 4 min.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Manuel Quintana

Data Engineer (Azure) Trainer

Manuel Quintana has been teaching and developing training content for Pragmatic Works for the past 6 years. The areas of knowledge he has worked with includes the Microsoft SQL BI Stack (T-SQL, SSIS, SSAS, and SSRS), the Power Platform (Power BI, Power Automate, and PowerApps), and other various Azure services. Manuel has also authored a couple of books around Power BI and the Power Platform and participates within the community by presenting topics at various SQL Server or Power BI User groups.

Learn More

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion