DAX for Microsoft Power BI Training Course

On our Microsoft Power BI course, you will learn how easy it is to import data into the Power BI Desktop and create powerful and dynamic visuals that bring your data to life. But what if you need to create your own calculated columns and measures; to have complete control over the calculations you need to perform on your data? DAX formulas provide this capability and many other important functions.

Learning how to create effective DAX formulas will help you get the most out of your data. When you get the information you need, you can begin to solve real business problems that affect your bottom line. This is Business Intelligence, and DAX will help you get there.

This course is available as both a public off-site course which you can book below, or as a private on-site course just for your business team. If you’re interested in a private course, it can be tailored to your custom needs and take place either at your offices or our training rooms in London. Please get in touch for a quote.

The course covers the ability to use Data Analysis Expressions (DAX) language to perform powerful data manipulations within Power BI Desktop. To get the most out of this course you should be a competent Microsoft Excel user. You don’t need any experience of using DAX but we recommend that you attend our 2-day Microsoft Power BI course prior to taking this course.

Public Courses

  • 13th Jul 2018 - 1 Day - At CitizenM, Lavington Street, London - £425.00 (Excl VAT) per person

    Book Now

Private Courses

Outline of our DAX for Microsoft Power BI Course - DURATION: 1 - DAY

Importing Your Data and Creating the Data Model

  • Overview of importing data into Power BI Desktop and creating the Data Model.

Using DAX

  • Syntax used by DAX.
  • Understanding DAX Data Types.

Creating Calculated Columns

  • How to use DAX expressions in Calculated Columns.
  • Using AND and OR operators (&& and ||).
  • Using BLANK and ISBLANK.
  • Using RELATED to look up values from related tables.
  • Understanding de-normalisation.

Creating Measures

  • Why use Measures and opposed to Calculated Columns?
  • Implicit and Explicit Measures.
  • How to Create a Measures using SUM & AVERAGE
  • Using COUNTROWS and DISTINCTCOUNT.
  • Using DAX aggregate functions; SUMX, AVERAGEX etc

Evaluation Context

  • What is Evaluation Context?
  • The difference between evaluations using Row Context and evaluations using Filter Context.

Working with Table Functions

  • Overview of DAX Functions that output Tables.
  • Using ALL, FILTER and VALUES functions.
  • Creating Parameter Tables.

CALCULATE Function

  • Exploring the importance of the CALCULATE function.
  • Using complex filters within CALCULATE using FILTER.
  • The difference between ALL and ALLSELECTED.

Time Intelligence Functions

  • Why Time Intelligence Functions?
  • Creating a Date Table.
  • Finding Month to Date, Year To Date, Previous Month and Same Period Last Year.
  • Creating Moving Annual Totals and Moving Averages

Working with Many-to-Many Relationships

  • The problem of Many-to-Many relationships
  • Creating a “Bridge Table”
  • Exploring the concept of "Expanded Tables"

Advanced Calculated Columns

  • Using CALCULATE in a Calculated Column.
  • Context Transition.
  • Using COUNTROWS and FILTER in Calculated Columns.
  • How the EARLIER function can be used in Row Context.

Speak to a trainer now

0800 0199 746 for any questions about the courses we offer