Microsoft Office training -  DAX

Power BI Tools Training

DAX (2 days)

£795 + VAT for most venues (£950 + VAT for London)

We have other courses which show how to create basic DAX measures as part of other applications, but this is the DAX course for hard-core programmers!  Learn how to create calculated columns and measures using DAX, and how to write DAX queries to interrogate databases.  On the way you'll pick up lots of clever techniques for building data models, including ways to model multiple calendars, parent-child hierarchies and dynamic security.  The course uses PowerPivot for editing measures, but the techniques learnt apply equally well to Power BI Desktop and Analysis Services (tabular model).

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking  (or consider an onsite Power BI Tools training course).

Course Contents

Data models

  • Training topicLinking to data
  • Training topicCreating a data model

Calculated columns

  • Training topicCreating calculated columns
  • Training topicIF and SWITCH
  • Training topicShowing RELATED data
  • Training topicDealing with blanks

Basic measures

  • Training topicCreating measures
  • Training topicUnderstanding filter context
  • Training topicUsing a measures table
  • Training topicAggregateX functions


  • Training topicThe CALCULATE function
  • Training topicRemoving and replacing context
  • Training topicThe FILTER function
  • Training topicVALUES: editing filter context

Understanding EARLIER

  • Training topicHow it works
  • Training topicBanding using EARLIER
  • Training topicRanking using EARLIER

Calendars and dates

  • Training topicCreating a calendar
  • Training topicDate-based functions

Advanced date functions

  • Training topicMultiple relationships
  • Training topicMoving averages
  • Training topicCreating a periods table

Covered if time allows If time

Dynamic security

  • Training topicCreating a permissions table
  • Training topicDynamic roles

Covered if time allows If time

Parent-child hierarchies

  • Training topicThe PATH functions
  • Training topicDisplaying different levels
  • Training topicMaking the results neater

DAX queries

  • Training topicEvaulating data
  • Training topicSummarising data
  • Training topicFiltering data
  • Training topicAdding columns

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Lots of handy info and manuals. Well presented. Even with little experience of SQL the course and the way it was presented was very helpful to me. It was overall one of the best courses that I have ever attended."

Lynne Jones (Aintree University Hospital NHS Foundation Trust)

"Enjoyed this course, good pace and exercises were fun."

Alexandra Russell (Pearson)

"The trainer was great. Took the time to ensure everyone was OK with what they were doing. Explained everything clearly. Content was good as it went from basic to more advanced."

Paul Matthews (PricewaterhouseCoopers Services Ltd.)

"Brilliant manual, contents and delivery."

Jennifer Dias (CNA Hardy)

"Great materials; the trainer was very clear and comprehensive and made a dry subject enjoyable."

Hannah Cotgrave (Wirral Borough Council)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You should be familiar with Excel pivot tables.  This course also requires a high degree of numeracy!

Related Courses

Introduction to Power BI Desktop


2 day course

PowerPivot / Excel Power BI


2 day course

Advanced Power BI Desktop


2 day course

Other Excel Power BI Tools and Desktop Power BI training resources

Power BI Tools exercises

Power BI Tools exercises

View Power BI Desktop or PowerPivot exercises

Power BI Tools videos

Power BI Tools videos

View Excel 2013 Power BI Tools videos

Power BI Tools blogs

Power BI Tools blogs

View Power BI - Excel or Power BI Desktop blogs

This page has 0 threads Add post