DAX (classroom or online)

Wise Owl

Training

In London and Manchester

£ 995 VAT inc.

The best Other Operating Systems courses

See all

See all

Description

  • Type

    Training

  • Level

    Intermediate

  • Location

    At 2 venues

  • Duration

    2 Days

  • Start date

    Different dates available

Learn how to create calculated columns and measures using DAX, understand complicated DAX functions like CALCULATE, VALUES and EARLIER, and learn how to write DAX queries to interrogate databases.

Important information

Documents

  • DAX course outline.pdf

Facilities

Location

Start date

London
See map
Holland House 1-4 Bury Street, EC3A 5AW

Start date

Different dates availableEnrolment now open
Manchester (Lancashire)
See map
Barlow House, Minshull Street, M1 3DZ

Start date

Different dates availableEnrolment now open

About this course

On the way you'll also 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 Power BI Desktop for editing measures, but is just as useful if you're using PowerPivot or SQL Server Analysis Services (tabular model).

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Ways to edit DAX
  • Data model basics
  • Calculated columns
  • Basic measures
  • The CALCULATE function
  • The FILTER function
  • Understanding EARLIER
  • Variables
  • Calendars and dates
  • Advanced date functions
  • Dynamic measures
  • DAX queries

Teachers and trainers (1)

Sam Lowrie

Sam Lowrie

Trainer

Course programme

Ways to edit DAX
  • Power BI
  • PowerPivot
  • SSAS Tabular
  • DAX Studio
Data model basics
  • Linking to data
  • Creating a data model
Calculated columns
  • Creating calculated columns
  • IF and SWITCH
  • Showing RELATED data
  • Dealing with blanks
Basic measures
  • Creating measures
  • Understanding filter context
  • Using a measures table
  • AggregateX functions
The CALCULATE function
  • Filter context revisited
  • Removing and replacing context
  • VALUES: editing filter context
The FILTER function
  • Row context
  • Iterator functions
  • Applying criteria
Understanding EARLIER
  • How it works
  • Banding using EARLIER
  • Ranking using EARLIER
Variables
  • Creating variables
  • Using for debugging
Calendars and dates
  • Creating a calendar
  • Date-based functions
Advanced date functions
  • Multiple relationships
  • Moving averages
Dynamic measures
  • The ISFILTERED function
  • The ALLSELECTED FUNCTION
  • Dynamic titles

If time

Parent-child hierarchies
  • The PATH functions
  • Displaying different levels
  • Making the results neater
DAX queries
  • Evaulating data
  • Summarising data
  • Filtering data
  • Adding columns

Additional information

£995 + VAT for most venues (£1,295 + VAT for London). £825 + VAT for online training.

See related categories

DAX (classroom or online)

£ 995 VAT inc.

The best Other Operating Systems courses

See all

See all