DAX Formulas for Power Pivot

Go back to Courses

DAX Formulas for Power Pivot

On-Demand

Author: Ken Puls

Average Rating: (0) Reviews

This is the video portion of the "DAX Formulas for Power Pivot" seminar with Ken Puls. Understanding DAX formulas is what takes your Power Pivot to the next level. This course is intended to help you up your DAX game so that you can make your PivotTables show the exact aggregations you need.

Course

DAX Formulas for Power Pivot

$249 Renews at $29 per year
(All prices in USD)

Buy now

This Course contains:

7 hours 30 minutes of training content

8 Content Modules

Downloadable files and Handouts

Certificate of completion

Check our Group Discounts here!

DURATION:

7 hours 30 minutes

TOOLS:

Excel

SKILLS:

DAX Formulas

Dimensional Modeling

What you'll learn?

Review of dimensional modelling terms and techniques and recommended practices

Building basic DAX measures from scratch

Understanding “Filter Context” and how it applies to formula calculation

Debugging a measure

Using CALCULATE() and ALL() to truly master your filter context

Advanced conditional logic patterns

Using iterator functions like SUMX() and AVERAGE()

Advanced time intelligence patterns

Course Overview

Course Description

While a well-related model is a core part of making Power Pivot sing, understanding DAX formulas is what really takes your Power Pivot to the next level. This course is intended to help you up your DAX game so that you can make your PivotTables show the exact aggregations you need. From creating simple measures to controlling % of grand totals which don’t lose their context upon filtering, to advanced patterns to control date period intelligence, we’ll cover it here.

If you’ve grown into Power Pivot but haven’t spent time studying DAX to any level of depth, this course is for you. After this course, you’ll be comfortable rolling your own custom measures to make your projects report EXACTLY the way you want.

A Note on Access

Your registration in the seminar comes with a free 3-month trial subscription to this video course. After the free trial period, you can choose to continue your access for $29 USD/year.

Who this course is for?

Accountants and data professionals who are responsible for building business intelligence reports.
Registrants must have experience using PivotTables and Power Pivot.

Course Formats

On-Demand

This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files, practice sets, and Q&A tests to validate your knowledge.

Course Content

Platform Introduction

3 Lessons

Course Examples

Course Introduction

Who’s Ken

Introduction to Power Pivot

6 Lessons

Where PivotTables Fail

Fact and Dimensions

Enter the Data Model

Relating the Tables

Creating Implicit Measures

Filtering, Ordering and Sorting

Introduction to DAX Formulae

8 Lessons

Aggregations, Measures and DAX

Basic Measure Syntax

Creating Basic Explicit Measures

Creating Compound Measures

Filter Context and Measure Calculation

Debugging Filter Context

Aggregating Dimensions

Why Relationships May Be Needed

Controlling Filter Context

4 Lessons

CALCULATE

Removing a Filter

Percent of Column Total Measures

Conditional DAX

Iterator Functions

3 Lessons

Challenge: Generate Cost by Line

Cost by Line Using Calculated Columns

Cost by Line Using Iterator Functions

Income Statement Patterns

4 Lessons

Challenge: Flipping Signs in a Column

Reporting Filter Context in a Pivot

Dealing with Multiple Values

Flipping Signs in a PivotTable Column

Calendar Intelligence

7 Lessons

DAX Functions – Extracting Date Components

DAX Functions – “x” to Date Measures

The Importance of a Calendar Dimension

DAX Functions – Previous/Next Period Measures

DAX Functions – Shifting Dates with DATEADD()

The Golden Date Pattern

Creating Calendar Safe Patterns

Help Resources

6 Lessons

Free Help Forums

Free Blogs

M is for (Data) Monkey

Power Query Recipes

Power Query Academy

Free Newsletters

How subscription works?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the author

Ken Puls

Microsoft MVP, FCPA, FCMA

Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.

FAQ

How do I access the course materials? Are they downloadable?

The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.

Where are the course videos hosted?

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.

How do I receive my Certificate of Completion?

After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard

Reviews

DAX Formulas for Power Pivot

(0 Review)

Reviews

There are no reviews yet.

Only verified customers who have purchased this product may leave a review.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.