Mastering DAX Video Course
This is the video course version of the Mastering DAX workshop. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language.
The goal of the course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. The video course is made up of over 15 hours of lectures, plus another 15-20 hours of individual exercises. You can watch the videos at anytime and the system will keep track of your progress. Within the course you can download the material for all the exercises.
Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.
Presentation of Mastering DAX 2nd Edition
Presentation of Mastering DAX 2nd Edition
FREE
Exercises, labs, slides, and demos
Exercises, labs, slides, and demos
FREE
How to download and complete exercises
FREE
Download exercises
Download demos
Slides of the video course
Introduction to DAX
Introduction to DAX
FREE
What is DAX?
FREE
DAX data types
FREE
Calculated columns
FREE
Measures
FREE
Aggregation functions
Counting values
Conditional functions
Handling errors
Using variables
Mathematical functions
Relational functions
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
02.10 - Average sales per customer
02.20 - Average delivery time
02.50 - Last update of customer
02.40 - Working days
02.30 - Discount categories
Table functions
Table functions
FREE
Introduction to table functions
Filtering a table
Ignoring filters
Mixing filters
Distinct
How many values for a column
ALLSELECTED
RELATEDTABLE
Tables and relationships
Tables with one row and one column
Table variables
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
03.20 - Percentage of sales
03.10 - Delivery working days
03.40 - Sales of products in the first week
03.30 - Customers with children
Evaluation contexts
Evaluation contexts
FREE
Introduction to evaluation contexts
Filter context
Row context
Context errors
Filtering a table
Using RELATED in a row context
Ranking by price
Evaluation contexts and relationships
Filters and relationships
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
04.10 - Nested iterators
04.20 - Customers in North America
05.10 - Create a parameter table
The CALCULATE function
The CALCULATE function
FREE
CALCULATE
CALCULATE examples
CALCULATE recap
What is a filter context?
KEEPFILTERS
CALCULATE operators
Use one column only in compact syntax
Variables and evaluation contexts
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
05.05 - Sales of red and blue products
05.20 - Understanding CALCULATE
05.25 - Sales of blue products
05.15 - Computing percentages
Advanced evaluation contexts
Advanced evaluation contexts
FREE
CALCULATE modifiers
USERELATIONSHIP
CROSSFILTER
ALL
ALLSELECTED
KEEPFILTERS
FREE
Context transition
Context transition /2
Circular dependency
CALCULATE execution order
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
05.35 - Correct sales of grey products
05.40 - Best customers
05.45 - Customers buying many products
05.50 - Large sales
05.30 - Percentage of customers
05.55 - Counting spikes
Iterators
Iterators
FREE
Working with iterators
MINX and MAXX
Useful iterators
RANKX
ISINSCOPE
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
07.10 - Ranking customers (static)
07.20 - Ranking customers (dynamic)
07.30 - Date with the highest sales
07.40 - Moving average
Building a date table
Building a date table
FREE
Introduction to date table
Auto Date/Time
CALENDARAUTO
Mark as date table
Using multiple dates
Time intelligence in DAX
Time intelligence in DAX
FREE
What is time intelligence?
FREE
Time intelligence functions
FREE
DATEADD
DATESINPERIOD
Running total
Mixing time intelligence functions
Semi-additive measures
Calculations over weeks
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
08.10 - Running total
08.20 - Comparison YOY%
08.30 - Sales in first three months
08.40 - Semi-additive calculations
Hierarchies in DAX
Hierarchies in DAX
FREE
What are hierarchies?
FILTER and CROSSFILTER
Percentages over hierarchies
Parent-child hierarchies
Querying with DAX
Querying with DAX
FREE
Working with tables and queries
EVALUATE
CALCULATETABLE
SELECTCOLUMNS
SUMMARIZE
SUMMARIZECOLUMNS
CROSSJOIN
TOPN and GENERATE
ROW and DATATABLE
Tables and relationships
UNION, INTERSECT, and EXCEPT
GROUPBY
Query measures
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
13.10 - Sales by year
13.20 - Filtering and grouping sales
13.30 - Using TOPN and GENERATE
13.40 - Sales to top customers
13.50 - Sales of top three colors
Data lineage and TREATAS
Data lineage and TREATAS
FREE
What is data lineage?
TREATAS
Expanded tables
Expanded tables
FREE
Filters are tables
Difference between base tables and expanded tables
Filtering a column
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
14.10 - Distinct count of countries
14.20 - Sales quantity greater than two
Arbitrarily shaped filters
Arbitrarily shaped filters
FREE
What are arbitrarily shaped filters?
Example of an arbitrarily shaped filter
ALLSELECTED and shadow filter contexts
ALLSELECTED and shadow filter contexts
FREE
ALLSELECTED
Shadow filter contexts
Segmentation
Segmentation
FREE
Static segmentation
Circular dependency in calculated tables
Dynamic segmentation
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
15.10 - Static segmentation
Many-to-many relationships
Many-to-many relationships
FREE
How to handle many-to-many relationships
Bidirectional filtering
Expanded table filtering
Comparison of the different techniques
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
15.30 - Many-to-many relationships
Ambiguity and bidirectional filters
Ambiguity and bidirectional filters
FREE
Understanding ambiguity
FREE
Relationships at different granularities
Relationships at different granularities
FREE
Working at different granularity
Using TREATAS
Calculated tables to slice dimensions
Leveraging weak relationships
Scenario recap
Checking granularity in the report
Hiding or reallocating
Additional exercises
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
14.30 - Same product sales
14.40 - Commentary on report
15.20 - New customers
Calculation groups
Calculation groups
FREE
Introducing calculation groups
FREE
Basic measures
Calculation items are patterns
Creating calculation groups
Changing the format string
Excluding specific measures
Using calculation items in DAX
Calculation item application
Calculation items on complex expressions
Multiple calculation groups in a report
Understanding precedence in calculation groups
Reusing calculation items
Recursion and best practices
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
09.10 - Time calculations
09.20 - Multiple calculation groups
09.30 - Sold versus delivered
09.40 - Min, Max and Avg calculation group
09.50 - Top and bottom products
Student Rating
Student Reviews (313)
Vladimir Pavlovic (Jan 31, 2024) Great course with the great examples and challenging excersices which are testing our knowledge from the course videos.
Connor T Daly (Jan 10, 2024) Great course! This along with your dax patterns book have helped me immensely. I now easily can think in Dax and can calmly solve most business problems I have encountered.
Vasilis Zois (Dec 31, 2023) really good course that goes from really basic things to really advanced
Tomasz Rembiasz (Dec 30, 2023) The most comprehensive Power BI and DAX course I have ever done. It's a waste of time and money to buy something else. If you want to learn, learn from the best!
Thank you!!!
Matteo Lorini (Dec 27, 2023) Grazie Mille, ottimo corso.
Karol Dorniak (Dec 20, 2023) towards becoming the Master of DAX!
Sébastien Kobenan (Dec 18, 2023) The best investment I made ever. Thank you very much Marco and Alberto and all your team.
Zhongxue Li (Dec 7, 2023) Well organized, very informative and the examples/excises are helpful while progressing the course.
Thank you!
Raghava Vedangi (Dec 6, 2023) Great tutorial and extremely helpful
carlos barboza (Dec 2, 2023) tour de force course! solid in every angle. molto grazie Marco and Alberto!
Arisha Khamitova (Nov 29, 2023) Very broad explanation for some formulas DAX. However, there are some features and solutions to them that are outdated. In some case it is dificult to understand the content due to not understanding well the meaning of some words such as filter context, iterators etc. I think there should be some vocabularly or introduction to this specific words.
Diogo Abreu (Nov 28, 2023) Exceptional Power BI course! Invaluable content propelled my career. Clear insights, practical skills—transformative learning experience!
Diogo Abreu (Nov 28, 2023) Great content. It was really relevant to my career
Erick Munoz (Nov 5, 2023) It was awesome, im still going through the exercises (so maybe its already addressed) but i would have like more complex problems involved
Petr Vajda (Nov 1, 2023) This video course exceeded my expectations. Exceptional performance by both lecturers. Thank you Peter
Would you prefer a classroom course?
This video course is based on a classroom course we teach all around the world. If you prefer a classroom learning experience, take a look at the dates below for a list of our upcoming classroom courses!
What is included
This video course contains 25 hours of training, for a total of 219 lectures.
Our training platform tracks your progress and resumes the course from where you left off.
The course is accessible on desktop and mobile browsers for
36 months after the purchase date .
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
After completing all the lectures in this video course,
you will be able to download a certificate of completion in PDF format from your student dashboard.
Options
Volume discounts are offered when you purchase multiple courses within one same order. To obtain the discount, just press the
Enroll Now button and add more courses or students in the next step. The discount cannot be applied to transferable licenses.
Amount
Discount
$ 400 +10% $ 800 +15% $ 1000 +20% $ 4000 +25%
You can get a group discount by registering 10 or more students to the same course. To obtain the discount, just press the
Enroll Now button and add more students in the next step.
Students
Discount
10+ 25% 25+ 30% 50+ 40% 100+ 50% 200+ 65% 300+ 70% 350+ 72%
This video course is also available with a transferable license, which is a convenient solution for teams.
License type
Price
Duration
Student(s)
Untransferable
$ 349
36 months
1
Transferable
$ 1390
36 months
Unlimited *
* The number of concurrent access reflects the number of licenses you have purchased. E.g. If you have a single transferable license, only one student can access the course at a time. To give another student access to the course, you must revoke the access and assign the license to the different student.
More on licenses
This video course is also available in the following bundles for enterprise customers:
Enterprise Essential Bundle Enterprise Essential Bundle (Transferable) Enterprise Advanced Bundle Enterprise Advanced Bundle (Transferable)
Enterprise bundles
Training Platform
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.
Learn more
Save the most interesting lectures for future use and easy access with bookmarks.
Press the marker button in every lecture and check the Bookmarks tab.
Learn more
You can highlight segments of the video transcripts, like you would with a printed book. Highlights are automatically saved and quickly accessible from your Bookmarks tab.
Learn more
In every section of this course, you will find an easy way to start a discussion about a topic relevant to the course.
Our team usually replies within a few hours!
Learn more
A team management dashboard is available if you choose to assign this course after the purchase or you get a transferable license.
Learn more