Power BI
DAX Essentials

About this course:

Without using DAX, you can only use 50% of Power BI’s capability. Although Power BI Dax is simple, with only a few fundamental concepts, it is not easy as these concepts require deep learning. That is why a lot of Power BI users think they know DAX until they realize their functions are not returning correct results.

This 2-Day Power BI 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 90% of 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 and 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.

Prerequisites:

This Power BI 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 T-SQL.

Who should take 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 the next level by writing custom calculations using DAX functions to address specific business requirements.

Upcoming Dates

Sydney

Date

Day

Training Mode

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

For Complete Schedule Click Here

Melbourne

Date

Day

Training Mode

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

For Complete Schedule Click Here

Brisbane

Date

Day

Training Mode

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

For Complete Schedule Click Here

Canberra

Date

Day

Training Mode

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

For Complete Schedule Click Here

Adelaide

Date

Day

Training Mode

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

For Complete Schedule Click Here

Perth

Date

Day

Training Mode

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

For Complete Schedule Click Here

Redirect Button
Now you're being redirected to our partner's website to complete the booking.....

Course Outline

✅ What is DAX

✅ What are the Data types in DAX

✅ DAX type handling/operator overloading

✅ DAX as Formula Language

✅ Vertipaq engine in DAX

✅ Difference between DAX, EXCEL functions, and M

✅ Dos, Don’ts, and Best Practices in DAX

✅ Fact vs Dimensions

✅ Schemas in Data Model

✅ Filter Propagation

✅ Data Denormalization

✅ Relationship Characteristics

✅ 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

✅ Two broad categories of functions in DAX

✅ Use of SUM(), DIVIDE() and COUNT()

✅ Use of DISTINCT COUNT ()

✅ Finding Min, Max, and Average

✅ Counting Rows

✅ Counting Blank Values

✅ What are the two evaluation contexts in DAX?

✅ What is the initial or incoming filter context

✅ What is Row Context

✅ Filter Context vs Row Context

✅ Rules of Evaluation

✅ Creating a Calculated Table

✅ Exploring Table Joins

✅ The Inner Join

✅ The Outer Join

✅ A Join on Unrelated tables – TREATAS()

✅ GENERATE() for Joins

✅ Creating a summary table for the requested totals using SUMMARIZE()

✅ Creating a summary table over a set of groups using SUMMARIZECOLOUMNS()

✅ Improve TREATAS() using SUMMARIZE()

✅ Getting the top N rows of the specified table using TOPN()

✅ Using VALUES()

✅ Using FILTER() as a Table function

✅ Virtual table lineage

✅ Creating & Optimizing Calendar Table using DAX

✅ Adding Date Columns

✅ Working with Fiscal Years

✅ Set sorting options

✅ Iterators vs. Normal Functions

✅ Using SUMX()

✅ Using COUNTX()

✅ Using AVERAGEX()

✅ Using MINX()

✅ Using MAXX()

✅ Creating Variables

✅ Features of a Variable

✅ Location of Variable Evaluation

✅ Conditional Computations using Variables

✅ Increasing Code Readability

✅ Writing single and multi-line comments

✅  Modification of Filter context using CALCULATE()

✅ Modification of multiple Filter using 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()

✅ Modify how filters are applied using KEEPFILTERS()

✅ Using SELECTEDVALUE()

✅ Using CONCATENATEX()

✅ Implicit Calculate in Measures

✅ Row to Filter Context transition

✅ Using CALCULATE() and CALCULATETABLE()

✅ Using EARLIER() vs EARLIEST()

✅ What is Time Intelligence

✅ Date table properties for Time Intelligence

✅ Aggregations over time

✅ Total Year till Date, Month Till Date, and Quarter till Date

✅ Handling Fiscal Year

✅ Same Period Last Year

✅ Calculate the Running Total

✅ Using date modifier DATESBETWEEN

✅ Shifting forward/backward in time using DATEADD()

✅ Using DATESINPERIOD()

✅ Using MAX or LASTDATE()

✅ Using FIRSTNONBLANK() and LASTNONBLANK()

✅ Total Sales rolling 90 days

✅ Use of IF( ) statements

✅ Switching between cases using SWITCH( )

✅ Finding your text

✅ What to do if your text had one value

✅ Concatenating labels

✅ Using COALESCE( )

✅ What are hierarchies

✅ Parent-child hierarchies

✅ Using Path functions

✅ Using RANKX() ✅ Dynamically controlling units ✅ Using COUNTA(), MINA(), MINAX()

✅ Common errors and causes

✅ Error debugging

✅ What is DAX Formatter

✅ Getting started with DAX Studio

✅ Downloading and Installing DAX Studio

✅ Connecting DAX Studio with Power BI

✅ Calculation performance using Data Studio

✅ Power BI Helper

✅ Clear the Cache

✅ Other DAX references

Australia's first choice for power BI training

Course was fantastic, I learnt so much. Will definitely recommend it. | Lauren

For some topics I needed more time to go through the examples, the trainer did assist me when I required assistance.| Rosie

Course structure and delivery were perfectly paced and presented. | Elliot
This was a really good course and very helpful. | Luke
5/5
4.7/5
5/5
4.5/5