Skip to main content
Get a Quote
Course Enquiry
Contact Us

Details

Both Microsoft (R) Power BI and Excel Power Pivots use DAX (Data Analysis eXpression Language) in order to analyze and transform data. To become a power user of either platform a functional knowledge of DAX is essential.

This course will build on your knowledge of either Power BI or Power Pivot creating more advanced formulas for your reports and dashboards.  In this course you will learn to:

  • Understand the structure of a DAX formula.
  • Use different types of DAX functions.
  • Understand the role of the Calendar table and use advanced time-intelligence functions.
  • Understand context in DAX both row and filter and the effect of relationships.
  • Use variables to improve the performance and readability of your formulas.
  • Use DAX to enforce Row Level Security on your reports in Power BI.

Cost

$350.00 If you are currently resident in South Africa you will need to pay VAT at 15%.

PC Hire:

$33.00
Or bring your own PC

Duration:

1 day

Brochure:

Download Brochure


Prices have changed from 1 March 2018. Information may change without notice.

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.

Audience

This course is intended for people who have been working with:

  • Power BI,
  • Excel Power Pivot
  • SSAS Tabular

 

Pre-Requisites

Some knowledge of one of the following:

  • Power BI,
  • Excel Power Pivot
  • SSAS Tabular

 

One should at the very least have experimented with DAX in the past.

 

Course Outline / Curriculum

  • Introduction to DAX
    • Data types and operators
    • Types of DAX Functions
    • Measures, calculated columns and calculated tables
    • Variables in DAX
    • DAX functions
      • Logical functions
      • Information functions
      • Mathematical functions
      • Text functions
      • Date and time functions
      • Rational functions
      • Table functions
        • FILTER
        • COUNTROWS
        • ALL and ALL EXCEPT
        • VALUES and DISTINCT
        • TOPN
        • ADDCOLUMN
        • SUMMARIZE
      • Statistical functions
  • Understanding evaluation context
    • Row and filter context
    • EARLIER
    • CALCULATE and CALCULATETABLE
    • USERELATIONSHIP
  • Time Intelligence
    • Understanding time intelligence
    • Working with data tables
    • Year-to-date and month to date calculations
    • Same period as last year calculations
    • Moving averages
    • Working with semi additive measures in DAX

Schedule Dates and Booking

There are currently no scheduled dates.

Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.

Add me to the waiting list

Should you need this course urgently, the following options are available:

  1. Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
  2. If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.