Platform Access

DAX Formula Patterns

Advanced course using Power BI & DAX to solve complex but common business problems and scenarios you'll face every day. This training is completely focused on how to use DAX formulas within Power BI to solve simple up to very advanced analytical problems.

Enroll Now
Dax Formula Patterns, DAX formula patterns course

Here's What You'll Get

With The Course

Over 5 hours of

video training

5x demo data sets for practical application

20x Power BI file (pbix file) resource

Dax Formula Patterns

Focused training on DAX formula within Power BI

  • Effortlessly write DAX formula that can solve even the most complicated questions by utilizing the power of DAX combined with the Power BI data model
  • Understand the core DAX concepts and formulas to branch out into a number of re-usable patterns that can be overlaid on a variety of datasets.

Details Of What You Will Learn

During This Course

  • Learn - how to use DAX in Power BI to solve common analytical problems
  • Use - DAX formula to bring compelling analytical works to life
  • Learn - advanced DAX measure branching techniques
  • Understand - what true analytical power you have when combining multiple techniques
  • Learn - how to look at raw data and then build up your DAX formula to get the answers that you need
Dax Formula Patterns

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Participants of this module should have basic knowledge and understanding of how to use Power BI and DAX. It is recommended to have completed the Ultimate Beginners Guide to Power BI and DAX, and the Power BI Super Users Workshop modules. No other advance preparation needed to take this course.

LEARN HOW TO

Utilize the key features within Power BI

Dax Formula Patterns
  • How to use DAX formulas within Power BI 
  • Utilising the power of DAX
  • Combined with the Power BI data model
  • Core DAX concepts and formulas
  • Combining multiple techniques
  • Branch out into a number of re-usable patterns
  • Comprehensive examples on a considerable amount of analytical scenarios
  • Solve common analytical problems using DAX in Power BI 
  • Compelling analytical works to life using DAX formula

Course Curriculum

1. Introduction to the Course

  • How to get certified for this course?

2. % of Total

  • Percent of Total - Simple
  • Percent of Total - Context Considerations

3. Moving Averages

  • Moving Averages - Simple
  • Re-using the Moving Averages Pattern

4. Cumulative Totals

  • Cumulative Totals Resource Materials
  • Cumulative Totals - ALL
  • Cumulative Totals - ALLSELECTED
  • Cumulative totals - Measure Branching
  • Review Questions
  • Review Question Feedback

5. Time Intelligence

  • Time Intelligence Materials
  • Time Intelligence Aggregations
  • Time Intelligence - Measure Branching
  • Percentage Change on Prior Period
  • DATEADD Function

6. Static Grouping

  • Grouping material
  • Grouping via Calculated Columns
  • Grouping via Lookup Table Logic

7. Dynamic Grouping

  • Dynamic Grouping via Support Tables
  • Dynamically Group Customers by Ranking

8. Events in Progress

  • Events in Progress material
  • Sales and Orders in Progress
  • Review Questions
  • Review Question Feedback

9. Budgeting

  • Budgeting material
  • Introduction to Budgeting
  • Extending Budgeting Models

10. Forecasting

  • Forecasting materials
  • Introduction to Forecasting
  • Extending Forecasting Models

11. Parameter Tables

  • Parameter tables material
  • Introduction to Parameter Tables
  • Extending Parameter Tables
  • Fixing Errors in Parameter Tables

12. Scenario Analysis

  • Advanced Scenario Analysis Techniques
  • Multi-Layered Scenario Analysis
  • Scenario Analysis

What our Students Say

Your Instructor

Sam McKay

Sam very early on saw the immense opportunity of using Power BI to create analytical solutions. After years of developing some advanced analysis and tools in excel, he was amazed that he could re-create most of those things in about 10% of the time with Power BI.

He is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organisations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.

Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charterholder, achieving the designation in 2011.

He has a passion for building highly scalable analytical solutions within organisations, and wants to see others learn how to do the same.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or CoE access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

On-Demand

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace