Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
DAX Formulas for Power Pivot
Course Content
Expand All
Platform Introduction
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Course Examples
Course Introduction
Who’s Ken
Extend Your Access
Introduction to Power Pivot
6 Lessons
Expand
Module Content
0% Complete
0/6 Steps
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
Expand
Module Content
0% Complete
0/8 Steps
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
Expand
Module Content
0% Complete
0/4 Steps
CALCULATE
Removing a Filter
Percent of Column Total Measures
Conditional DAX
Iterator Functions
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Challenge: Generate Cost by Line
Cost by Line Using Calculated Columns
Cost by Line Using Iterator Functions
Income Statement Patterns
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
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
Expand
Module Content
0% Complete
0/7 Steps
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
Expand
Module Content
0% Complete
0/6 Steps
Free Help Forums
Free Blogs
M is for (Data) Monkey
Power Query Recipes
Power Query Academy
Free Newsletters