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 Dates
-
Sydney Class Dates
Book NowLevel 11, 32 Walker Street, North Sydney , NSW 2060
26 - 27 May 22 Thu - Fri Online Live 06 - 07 Jun 22 Mon - Tue Online Live 16 - 17 Jun 22 Thu - Fri Classroom 23 - 24 Jun 22 Thu - Fri Online Live 07 - 08 Jul 22 Thu - Fri Online Live 11 - 12 Jul 22 Mon - Tue Classroom 18 - 19 Jul 22 Mon - Tue Online Live 04 - 05 Aug 22 Thu - Fri Online Live 11 - 12 Aug 22 Thu - Fri Classroom 18 - 19 Aug 22 Thu - Fri Online Live 30 - 31 Aug 22 Tue - Wed Online Live 05 - 06 Sep 22 Mon - Tue Classroom 15 - 16 Sep 22 Thu - Fri Online Live 26 - 27 Sep 22 Mon - Tue Online Live 06 - 07 Oct 22 Thu - Fri Classroom 13 - 14 Oct 22 Thu - Fri Online Live 26 - 27 Oct 22 Wed - Thu Online Live 31 Oct - 01 Nov 22 Mon - Tue Classroom 10 - 11 Nov 22 Thu - Fri Online Live 21 - 22 Nov 22 Mon - Tue Online Live 28 - 29 Nov 22 Mon - Tue Classroom 08 - 09 Dec 22 Thu - Fri Online Live 19 - 20 Dec 22 Mon - Tue Online Live -
Melbourne Class Dates
Book NowLevel 12, 379 Collins Street, Melbourne , VIC 3000
26 - 27 May 22 Thu - Fri Online Live 31 May - 01 Jun 22 Tue - Wed Classroom 06 - 07 Jun 22 Mon - Tue Online Live 23 - 24 Jun 22 Thu - Fri Online Live 30 Jun - 01 Jul 22 Thu - Fri Classroom 07 - 08 Jul 22 Thu - Fri Online Live 18 - 19 Jul 22 Mon - Tue Online Live 28 - 29 Jul 22 Thu - Fri Classroom 04 - 05 Aug 22 Thu - Fri Online Live 18 - 19 Aug 22 Thu - Fri Online Live 24 - 25 Aug 22 Wed - Thu Classroom 30 - 31 Aug 22 Tue - Wed Online Live 15 - 16 Sep 22 Thu - Fri Online Live 21 - 22 Sep 22 Wed - Thu Classroom 26 - 27 Sep 22 Mon - Tue Online Live 13 - 14 Oct 22 Thu - Fri Online Live 20 - 21 Oct 22 Thu - Fri Classroom 26 - 27 Oct 22 Wed - Thu Online Live 10 - 11 Nov 22 Thu - Fri Online Live 14 - 15 Nov 22 Mon - Tue Classroom 21 - 22 Nov 22 Mon - Tue Online Live 08 - 09 Dec 22 Thu - Fri Online Live 15 - 16 Dec 22 Thu - Fri Classroom 19 - 20 Dec 22 Mon - Tue Online Live -
Brisbane Class Dates
Book NowLevel 6, 371 Queen Street, Brisbane , QLD 4000
26 - 27 May 22 Thu - Fri Online Live 06 - 07 Jun 22 Mon - Tue Online Live 09 - 10 Jun 22 Thu - Fri Classroom 23 - 24 Jun 22 Thu - Fri Online Live 07 - 08 Jul 22 Thu - Fri Online Live 14 - 15 Jul 22 Thu - Fri Classroom 18 - 19 Jul 22 Mon - Tue Online Live 04 - 05 Aug 22 Thu - Fri Online Live 15 - 16 Aug 22 Mon - Tue Classroom 18 - 19 Aug 22 Thu - Fri Online Live 30 - 31 Aug 22 Tue - Wed Online Live 15 - 16 Sep 22 Thu - Fri Online Live 22 - 23 Sep 22 Thu - Fri Classroom 26 - 27 Sep 22 Mon - Tue Online Live 13 - 14 Oct 22 Thu - Fri Online Live 24 - 25 Oct 22 Mon - Tue Classroom 26 - 27 Oct 22 Wed - Thu Online Live 10 - 11 Nov 22 Thu - Fri Online Live 21 - 22 Nov 22 Mon - Tue Classroom 21 - 22 Nov 22 Mon - Tue Online Live 08 - 09 Dec 22 Thu - Fri Online Live 15 - 16 Dec 22 Thu - Fri Classroom 19 - 20 Dec 22 Mon - Tue Online Live
-
Canberra Class Dates
Book NowAll courses facilitated in, Online Live format ,
26 - 27 May 22 Thu - Fri Online Live 06 - 07 Jun 22 Mon - Tue Online Live 23 - 24 Jun 22 Thu - Fri Online Live 07 - 08 Jul 22 Thu - Fri Online Live 18 - 19 Jul 22 Mon - Tue Online Live 04 - 05 Aug 22 Thu - Fri Online Live 18 - 19 Aug 22 Thu - Fri Online Live 30 - 31 Aug 22 Tue - Wed Online Live 15 - 16 Sep 22 Thu - Fri Online Live 26 - 27 Sep 22 Mon - Tue Online Live 13 - 14 Oct 22 Thu - Fri Online Live 26 - 27 Oct 22 Wed - Thu Online Live 10 - 11 Nov 22 Thu - Fri Online Live 21 - 22 Nov 22 Mon - Tue Online Live 08 - 09 Dec 22 Thu - Fri Online Live 19 - 20 Dec 22 Mon - Tue Online Live -
Adelaide Class Dates
Book NowAll courses facilitated in, Online Live format ,
26 - 27 May 22 Thu - Fri Online Live 06 - 07 Jun 22 Mon - Tue Online Live 23 - 24 Jun 22 Thu - Fri Online Live 07 - 08 Jul 22 Thu - Fri Online Live 18 - 19 Jul 22 Mon - Tue Online Live 04 - 05 Aug 22 Thu - Fri Online Live 18 - 19 Aug 22 Thu - Fri Online Live 30 - 31 Aug 22 Tue - Wed Online Live 15 - 16 Sep 22 Thu - Fri Online Live 26 - 27 Sep 22 Mon - Tue Online Live 13 - 14 Oct 22 Thu - Fri Online Live 26 - 27 Oct 22 Wed - Thu Online Live 10 - 11 Nov 22 Thu - Fri Online Live 21 - 22 Nov 22 Mon - Tue Online Live 08 - 09 Dec 22 Thu - Fri Online Live 19 - 20 Dec 22 Mon - Tue Online Live -
Perth Class Dates
Book NowAll courses facilitated in, Online Live format ,
26 - 27 May 22 Thu - Fri Online Live 06 - 07 Jun 22 Mon - Tue Online Live 23 - 24 Jun 22 Thu - Fri Online Live 07 - 08 Jul 22 Thu - Fri Online Live 18 - 19 Jul 22 Mon - Tue Online Live 04 - 05 Aug 22 Thu - Fri Online Live 18 - 19 Aug 22 Thu - Fri Online Live 30 - 31 Aug 22 Tue - Wed Online Live 15 - 16 Sep 22 Thu - Fri Online Live 26 - 27 Sep 22 Mon - Tue Online Live 13 - 14 Oct 22 Thu - Fri Online Live 26 - 27 Oct 22 Wed - Thu Online Live 10 - 11 Nov 22 Thu - Fri Online Live 21 - 22 Nov 22 Mon - Tue Online Live 08 - 09 Dec 22 Thu - Fri Online Live 19 - 20 Dec 22 Mon - Tue Online Live
Course Units
Expand full topic list
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
See more
Unit 2: Data Modelling Recap
- Fact vs Dimensions
- Understanding Schemas in Data Model
- Understanding Filter Propagation
- Understanding Data Denormalization
- Understanding Relationship Characteristics
See more
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
See more
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
See more
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
See more
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
See more
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
See more
Unit 8: Basic Iterators
- Iterators vs. Normal Functions
- Using SUMX()
- Using COUNTX()
- Using AVERAGEX()
- Using MINX()
- Using MAXX()
See more
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
See more
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()
See more
Unit 11: Context Transition
- Understanding Implicit Calculate in Measures
- Understanding Row to Filter Context transition
- Using CALCULATE() and CALCULATETABLE()
- Using EARIER() vs EARLIEST()
See more
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
See more
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()
See more
Unit 14: Hierarchies In DAX
- What are Hierarchies
- Understanding Parent-child Hierarchies
- Using Path Functions
See more
Unit 15: Other Functions
- Using RANKX()
- Understanding Dynamically controlling units
- Using COUNTA()
- Using MINA()
- Using MINAX()
See more
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
See more
Related Courses
Course Reviews
(5.00 out of 5) Luke [ 21 April, 2022 ]
Ali is an excellent trainer. I undertaken numerous computing courses over the years and I found Ali to be up there with the very best.
(5.00 out of 5) Dan T [ 03 March, 2022 ]
Adam knows his stuff and is very easy to follow, I'm not sure I'll use all the DAX formulas but it was still good to see.
(5.00 out of 5) Dallas M [ 03 March, 2022 ]
Excellent! Well done Adam
Looking fwd to more now. Around loading in alternate data sources dynamically.
(5.00 out of 5) Kasun G [ 03 March, 2022 ]
Power BI DAX Essentials course is well worth and I am sure it helps in many ways to make our work easier and smarter.
Enquire Now
Fill in your details to have a training consultant contact you to discuss your training needs.