Full star Half star Star PDF
The Ultimate Training Experience.

Power BI DAX Essentials Course

(4.91 out of 5) 228 Student Reviews

About the Course

This 2-Day course is designed to lay solid foundations before diving deep into complex DAX functions. This is achieved by focusing on 2 key elements i.e. engagement, and practicality. Participants will be spending their time writing hands-on DAX functions, looking at the result, discussing what works, and especially what does not work and WHY? Additionally, all the modules and concepts are reinforced by real-life, scenario-based examples to solidify the learnings.

After this course, participants should be able to write DAX expressions to address their specific business needs, leverage available resources to tackle complex problems, debug and optimize using available tools and the right techniques. Moreover, the entire course walks through a single data set so participants can concentrate on mastering the concepts rather than worrying about the specifics of the dataset.

Who should do this course?

This course is for business users (Finance, Marketing, Operations etc.) or SQL Server report creators who want to take their reports and dashboards to a next level by writing custom calculations using DAX functions to address specific business requirements.

Prerequisites

This DAX course is suitable for people who have either completed the Power BI essentials course or have a reasonable understanding of data modeling concepts. To benefit most from this course, participants must have some expertise in using excel functions or SQL.

Course Details

$990 incl GST

  • Duration:2 Days
  • Max. Class Size:10
  • Avg. Class Size:5
  • Study Mode:
    Classroom Online Live
  • Level:Advanced
  • Course Times: Classroom: 9.00am to 5.00pm approx(Local Time) Online Live: 9.00am to 5.00pm approx(AEST or AEDT)
  • Download Course PDF
Pay Later

Course Dates

Sydney Class Dates

Level 11, 32 Walker Street, North Sydney , NSW 2060

15 - 16 Apr 24 Mon - Tue Online Live
18 - 19 Apr 24 Thu - Fri Classroom
22 - 23 Apr 24 Mon - Tue Online Live
02 - 03 May 24 Thu - Fri Online Live
13 - 14 May 24 Mon - Tue Classroom
15 - 16 May 24 Wed - Thu Online Live
30 - 31 May 24 Thu - Fri Online Live
13 - 14 Jun 24 Thu - Fri Classroom
13 - 14 Jun 24 Thu - Fri Online Live
24 - 25 Jun 24 Mon - Tue Online Live
08 - 09 Jul 24 Mon - Tue Classroom
11 - 12 Jul 24 Thu - Fri Online Live
17 - 18 Jul 24 Wed - Thu Online Live
22 - 23 Jul 24 Mon - Tue Online Live
07 - 08 Aug 24 Wed - Thu Classroom
08 - 09 Aug 24 Thu - Fri Online Live
19 - 20 Aug 24 Mon - Tue Online Live
02 - 03 Sep 24 Mon - Tue Classroom
03 - 04 Sep 24 Tue - Wed Online Live
19 - 20 Sep 24 Thu - Fri Online Live
Melbourne Class Dates

Level 12, 379 Collins Street, Melbourne , VIC 3000

15 - 16 Apr 24 Mon - Tue Online Live
22 - 23 Apr 24 Mon - Tue Online Live
23 - 24 Apr 24 Tue - Wed Classroom
02 - 03 May 24 Thu - Fri Online Live
15 - 16 May 24 Wed - Thu Online Live
21 - 22 May 24 Tue - Wed Classroom
30 - 31 May 24 Thu - Fri Online Live
13 - 14 Jun 24 Thu - Fri Online Live
19 - 20 Jun 24 Wed - Thu Classroom
24 - 25 Jun 24 Mon - Tue Online Live
11 - 12 Jul 24 Thu - Fri Online Live
16 - 17 Jul 24 Tue - Wed Classroom
17 - 18 Jul 24 Wed - Thu Online Live
22 - 23 Jul 24 Mon - Tue Online Live
08 - 09 Aug 24 Thu - Fri Online Live
15 - 16 Aug 24 Thu - Fri Classroom
19 - 20 Aug 24 Mon - Tue Online Live
03 - 04 Sep 24 Tue - Wed Online Live
09 - 10 Sep 24 Mon - Tue Classroom
19 - 20 Sep 24 Thu - Fri Online Live
Brisbane Class Dates

Level 6, 371 Queen Street, Brisbane , QLD 4000

15 - 16 Apr 24 Mon - Tue Classroom
15 - 16 Apr 24 Mon - Tue Online Live
22 - 23 Apr 24 Mon - Tue Online Live
02 - 03 May 24 Thu - Fri Online Live
15 - 16 May 24 Wed - Thu Online Live
20 - 21 May 24 Mon - Tue Classroom
30 - 31 May 24 Thu - Fri Online Live
13 - 14 Jun 24 Thu - Fri Online Live
24 - 25 Jun 24 Mon - Tue Online Live
11 - 12 Jul 24 Thu - Fri Online Live
15 - 16 Jul 24 Mon - Tue Classroom
17 - 18 Jul 24 Wed - Thu Online Live
22 - 23 Jul 24 Mon - Tue Online Live
08 - 09 Aug 24 Thu - Fri Online Live
19 - 20 Aug 24 Mon - Tue Online Live
03 - 04 Sep 24 Tue - Wed Online Live
09 - 10 Sep 24 Mon - Tue Classroom
19 - 20 Sep 24 Thu - Fri Online Live
14 - 15 Nov 24 Thu - Fri Classroom
Canberra Class Dates

All courses facilitated in, Online Live format ,

15 - 16 Apr 24 Mon - Tue Online Live
22 - 23 Apr 24 Mon - Tue Online Live
02 - 03 May 24 Thu - Fri Online Live
15 - 16 May 24 Wed - Thu Online Live
30 - 31 May 24 Thu - Fri Online Live
13 - 14 Jun 24 Thu - Fri Online Live
24 - 25 Jun 24 Mon - Tue Online Live
11 - 12 Jul 24 Thu - Fri Online Live
17 - 18 Jul 24 Wed - Thu Online Live
22 - 23 Jul 24 Mon - Tue Online Live
08 - 09 Aug 24 Thu - Fri Online Live
19 - 20 Aug 24 Mon - Tue Online Live
03 - 04 Sep 24 Tue - Wed Online Live
19 - 20 Sep 24 Thu - Fri Online Live
Adelaide Class Dates

All courses facilitated in, Online Live format ,

15 - 16 Apr 24 Mon - Tue Online Live
22 - 23 Apr 24 Mon - Tue Online Live
02 - 03 May 24 Thu - Fri Online Live
15 - 16 May 24 Wed - Thu Online Live
30 - 31 May 24 Thu - Fri Online Live
13 - 14 Jun 24 Thu - Fri Online Live
24 - 25 Jun 24 Mon - Tue Online Live
11 - 12 Jul 24 Thu - Fri Online Live
17 - 18 Jul 24 Wed - Thu Online Live
22 - 23 Jul 24 Mon - Tue Online Live
08 - 09 Aug 24 Thu - Fri Online Live
19 - 20 Aug 24 Mon - Tue Online Live
03 - 04 Sep 24 Tue - Wed Online Live
19 - 20 Sep 24 Thu - Fri Online Live
Perth Class Dates

All courses facilitated in, Online Live format ,

15 - 16 Apr 24 Mon - Tue Online Live
22 - 23 Apr 24 Mon - Tue Online Live
02 - 03 May 24 Thu - Fri Online Live
15 - 16 May 24 Wed - Thu Online Live
30 - 31 May 24 Thu - Fri Online Live
13 - 14 Jun 24 Thu - Fri Online Live
24 - 25 Jun 24 Mon - Tue Online Live
11 - 12 Jul 24 Thu - Fri Online Live
17 - 18 Jul 24 Wed - Thu Online Live
22 - 23 Jul 24 Mon - Tue Online Live
08 - 09 Aug 24 Thu - Fri Online Live
19 - 20 Aug 24 Mon - Tue Online Live
03 - 04 Sep 24 Tue - Wed Online Live
19 - 20 Sep 24 Thu - Fri Online Live

Course Units

Unit 1: Getting to know Data Analysis Expression (DAX) Language

  • What is DAX?
  • Understanding the Data types in DAX
  • Understanding DAX Type Handling
  • Understanding DAX Operator Overloading
  • Learning DAX as Formula Language
  • Vertipaq Engine in DAX
  • Difference between DAX, EXCEL Functions and M
  • Do's, Dont's and Best Practices in DAX

Unit 2: Data Modelling Recap

  • Fact vs Dimensions
  • Understanding Schemas in Data Model
  • Understanding Filter Propagation
  • Understanding Data Denormalization
  • Understanding Relationship Characteristics

Unit 3: Calculated Columns and Measures

  • Calculated Column and its Use Case
  • When do Calculated Columns Fail
  • Calculated Measure and its Use Case
  • When to use Calculated Column vs Calculated Measure

Unit 4: Basic DAX Functions

  • Understanding Two Broad Categories of Functions in DAX
  • Using SUM()
  • Using DIVIDE()
  • Using COUNT()
  • Using DISTINCTCOUNT ()
  • Finding Min, Max and Average
  • Counting Rows
  • Counting Blank Values

Unit 5: Evaluation Contexts in DAX

  • What are the Two Evaluation Contexts in DAX?
  • What is Initial or Incoming Filter Context
  • What is Row Context
  • Filter Context vs Row Context
  • Rules of Evaluation

Unit 6: Table Functions

  • Creating a Calculated Table
  • Exploring Table Joins
  • The Inner Join
  • The Outer Join
  • The Cross Join
  • A Join on Unrelated Tables – TREATAS()
  • Using GENERATE() for Joins
  • Creating Summary Table for the Tequested Totals Using SUMMARIZE()
  • Creating Summary Table Over a Set of Groups Using SUMMARIZECOLOUMNS()
  • Improving TREATAS() using SUMMARIZE()
  • Getting Top N rows of the Specified Table Using TOPN()
  • Using VALUES()
  • Using FILTER() as a Table Function
  • Understanding Virtual Table Lineage

Unit 7: Creating Date Table

  • Creating Calendar Table using DAX
  • Optimising Calendar Table using DAX
  • Adding Date Columns
  • Working with Fiscal Years
  • Setting Sorting Options

Unit 8: Basic Iterators

  • Iterators vs. Normal Functions
  • Using SUMX()
  • Using COUNTX()
  • Using AVERAGEX()
  • Using MINX()
  • Using MAXX()

Unit 9: Variables in DAX

  • Creating Variables
  • Features of a Variable
  • Location of Variable Evaluation
  • Conditional Computations using Variables
  • Increasing Code Readability
  • Writing single and multi-line comments

Unit 10: Advance Filtering in DAX

  • Modification of Filter context using CALCULATE()
  • Modification of multiple Filter using with CALCULATE()
  • Mixing Filtering
  • Using LOOKUPVALUE()
  • Specifying the cross-filtering direction using CROSSFILTER()
  • Activating Relationships with USERELATIONSHIP()
  • Return all the rows in a table using All()
  • Using ALLSELECTED()
  • Using ALLEXCEPT()
  • Modify how filters are applied using KEEPFILTERS()
  • Using SELECTEDVALUE()
  • Using CONCATENATEX()

Unit 11: Context Transition

  • Understanding Implicit Calculate in Measures
  • Understanding Row to Filter Context transition
  • Using CALCULATE() and CALCULATETABLE()
  • Using EARIER() vs EARLIEST()

Unit 12: Time Intellegence in DAX

  • What is Time Intelligence
  • Understanding Date table properties for Time Intelligence
  • Aggregations Over Time
  • Understanding Total Year till Date
  • Understanding Month Till Date
  • Understanding Quarter till Date
  • Handling Fiscal Year
  • Same Period Last Year
  • Calculating Running Total
  • Using Date Modifier DATESBETWEEN
  • Shifting Forward/Backward in time using DATEADD()
  • Using DATESINPERIOD()
  • Using MAX or LASTDATE()
  • Using FIRSTNONBLANK() and LASTNONBLANK()
  • Working with Total Sales Rolling 90 Days

Unit 13: Conditionals in DAX

  • Using IF() statements
  • Switching between Cases using SWITCH()
  • Finding your Text
  • What to do if your Text had One Value
  • Concatenating Labels
  • Using COALESCE()

Unit 14: Hierarchies In DAX

  • What are Hierarchies
  • Understanding Parent-child Hierarchies
  • Using Path Functions

Unit 15: Other Functions

  • Using RANKX()
  • Understanding Dynamically controlling units
  • Using COUNTA()
  • Using MINA()
  • Using MINAX()

Unit 16: DAX Tools and Other Resources

  • Understanding Common Errors and Causes
  • Working with Error Debugging
  • Understanding DAX Formatter
  • Getting started with DAX Studio
  • Downloading and Installing DAX Studio
  • Connecting DAX Studio with Power BI
  • Calculating Performance using Data Studio
  • Understanding Power BI Helper
  • Clearing the Cache
  • Other DAX References

Training Packages

Complete Power BI Package

$ 2431 incl GST
(You save $429)
Total Duration
6 days
Pay Later

Related Courses

Course Reviews

(5.00 out of 5) [ 04 April, 2024 ]

White board was fantastic, able to answer examples, I thought the asking people to reflect the question back to the common dataset was a good idea. This was the most useful out of all of the BI courses offered.

(5.00 out of 5) [ 21 March, 2024 ]

This is my first time taking a course with Ali. Ali's style of teaching is clear, direct and practical. Ali is very passion with Power BI, he has heaps of knowledge and heaps of relevant examples. @Ali, Thank you so much for sharing your knowledge and your passion in Power BI.

(5.00 out of 5) [ 21 March, 2024 ]

Course content was well designed. Instructor demonstrated excellent skills to teach the content with illustrated examples and hands on exercises also provided direction on work related problems.

(5.00 out of 5) [ 21 March, 2024 ]

THIS IS JUST AMAZING! Especially, the trainer --> ALI understood and answered all questions. One of the best trainers!

Read all course reviews

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Note: Form fields marked with * are required.

Your details
Please enter a valid email address for shipping updates.
I am enquiring about a...
Complete Power BI Package

Book our 4 core Power BI course together and
SAVE $429


For more info please

Call 1300 888 724

View Package Details

REQUEST A CALLBACK
A team member will call you at a time convenient to you.
Your message was sent, thank you!
Contact us

Level 11, 32 Walker Street, North Sydney NSW, 2060