Courses

Certifications

Instructors

Mastering DAX for Microsoft Power BI

Learn the full range of DAX functions in Power BI.

DAX is the native language behind Microsoft PowerBI and other Microsoft data tools. It’s designed as a flexible, powerful syntax for working with various data types and crafting functions to manipulate and analyze data.

Even for beginners, PowerBI out of the box offers incredible analysis capability. However, for those who are comfortable with basic features and are ready to truly unlock PowerBI’s potential, DAX is the key. Learning to use DAX within PowerBI gives you the power to perform incredibly fine-grained analysis and data manipulation.

In this class, you will get hands-on experience with DAX and learn it’s full range of functions. Led by an expert, you’ll get practice applying DAX skills to real-world datasets and real-world analysis problems. You’ll leave class ready to extend your role well beyond that of most PowerBI users – applying skills to manipulate, analyze, and communicate about data precisely and powerfully.

Duration

3 days/24 hours of instruction

Public Classroom Pricing

$1795(USD)

GSA Price: $1685

Group Rate: $1695

Private Group Pricing

Have a group of 5 or more students? Request special pricing for private group training today.

Download the Course Brochure

Part 1: Introduction to DAX

What is DAX?
Why use DAX with Power BI
Calculated Columns vs Measures
Types of Functions
1. Logical Functions
2. Table manipulation functions
3. Date and time functions
4. Filter functions
5. Financial functions
6. Math and Trig functions
7. Parent and Child functions
8. Relationship functions
9. Statistical functions
10. Text functions
11. Time intelligence functions

Part 2: Logical functions

TRUE
FALSE
IF
IFERROR
AND
OR
SWITCH
COALESCE

Part 3: Tables

Tables Overview
Filtering Tables
1. FILTERS
2. TOPN
Summarizing Tables
1. SUMMARIZE
2. SUMMARIZECOLUMNS
3. ROLLUP
4. GROUPBY
Generating Tables
Distinct Values
1. DISTINCT column
2. DISTINCT table
Joining Tables
1. CROSSJOIN
2. NATURALINNERJOIN
3. NATURALLEFTOUTERJOIN
Adding Values
1. Columns
2. Missing items
Table Constructor

Part 4: Date and Time Functions

Date and Time Functions Overviews
Units of Time
Creating a Calendar
1. CALENDAR
2. CALENDARAUTO
Dates
TODAY
NOW
TIME
TIMEVALUE

Part 5: Filter Functions

Filter Functions Overview
Filtering Tables
1. FILTER
2. REMOVEFILTERS
3. ALL (ALL, ALLCROSSFILTERED, ALLEXCEPT, ALLNOBLANKROW, & ALLSELECTED)
4. CALCULATETABLE
5. KEEPFILTERS
CALCULATE
LOOKUPVALUE
SELECTEDVALUE

Part 6: Financial functions

Accrued Interest
1. ACCRINT
2. ACCRINTM
Depreciation
1. DB
2. DDB

Part 7: Relationships Functions

CROSSFILTERS
RELATED
RELATEDTABLE
USERELATIONSHIP
Parent and Child Functions
1. PATH
2. PATHCONTAINS
3. PATHITEM
4. PATHITEMREVERSE

Part 8: Text functions

FIND
SEARCH
REPLACE
FORMAT
LOWER
UPPER
RIGHT
LEFT
COMBINEVALUES
CONCATENATE
CONCATENATEX
EXACT
FIXED
LEN
MID
SUBSTITUTE
TRIM
VALUE

Part 9: Statistical functions

Central Tendencies
1. Averages
2. Means
3. Geo means
Counting
1. Counting and COUNTX
2. Blanks, and rows
3. Distinct count: distinct, approximate, no blank
Min/Max
1. MAX, MAXA and MAXX
2. MIN, MINA and MINX
Sample
Distributions
1. Normal
2. Exponential
3. Beta
4. Poisson
Inverse
Percentiles
Ranking
Standard Deviation
Variance
1. VAR.P and VARX.P
2. VAR.S and VARS.P

Professionals who take this course need to be familiar with Microsoft Power BI’s basic features and already feel comfortable with navigating both the Desktop and Online version of the tool. It is recommended to take our Microsoft Power BI Boot Camp prior to this course, or have equivalent work experience.

Some professionals who would find this course particularly beneficial include:

Analysts
Database Administrators
Senior Business Intelligence Architects
Business Intelligence Consultants
Senior Business Analysts
Digital Marketers
Data Strategists
IT Specialists
IT Managers
IT Directors
Financial Specialists

Apply a wide range of available DAX functions and when you should use them
Manipulate data based on date, time, currency, integer values, and more
Expertly analyze data using powerful statistical functions
Build and manipulate tables with a wide range of data sources
Design and analyze data using boolean logic
Tease apart sophisticated data relationships to find insights
Filter through large data sets quickly and effortlessly
Work with and manipulate text values in Power BI