Complete DAX Bootcamp for Power BI from Beginner to Advanced

Name: Complete DAX Bootcamp for Power BI from Beginner to Advanced
Rating: 4.3 (447 reviews)

Complete DAX Training: Start from Scratch and Advance in Power BI. Master Data Analysis and reporting skills effectively

Bestseller

Created byBalamurugan Sivasangar

Last updated 3/2025

English

What you'll learn

Learn Data Analysis Expressions (DAX) from scratch
Complete DAX Bootcamp with assignments and solution walkthrough
DAX Functions with Demo, DAX Statements, Visual Calculations
Data Transformation Fundamentals to get started
Data Modeling Fundamentals to get started

Course content

22 sections • 178 lectures • 14h 14m total length

Course Structure and Introduction1:58
Setting up things ready1:25
Important Note : Who is this course for0:28
This course is completely on DAX, even though have covered Data transformation fundamentals, Data modeling fundamentals prerequisite to get started.

What You Will Learn:
Data Transformation Fundamentals (Prerequisite) : Master the essential techniques for transforming raw data into a structured format, ready for analysis. Learn how to clean, reshape, and preprocess data to meet your analytical needs.
Data Modeling Fundamentals (Prerequisite) : Build a solid foundation in data modeling principles. Discover how to design and implement effective data models to ensure accurate and efficient analysis.
DAX from Scratch: Start with the basics of DAX (Data Analysis Expressions) and progress to advanced concepts. Learn how to create powerful calculations, measures, and columns, Context, Visual calculations, etc...
Download resource (Data sets)0:03

Section Introduction0:28
Install Power BI desktop and download the course datasets. Import, clean, and transform the data in Power Query, then load it into Power BI and build a standalone date table.
Getting Data3:37
Transform Data in Power Query13:43
Date Table in Power Query4:34
Create a standalone date table in Power Query to support yearly, quarterly, and weekly visuals by adding year, month, quarter, and week columns and linking to sales and customer data.
Loading and wrapping up data transformation0:44

Section Introduction0:29
Explore what DAX is, how the DAX engine works, and distinguish measure, calculated column, and calculated table, including implicit versus explicit measure.
What is DAX1:57
The DAX Engine1:15
What is Calculated Column & Calculated Table2:39
What is Measure3:07
Learn to create a measure that sums product cost in Power BI, and compare calculated columns with measures, including when to use each in visuals like cards, tables, and slicers.
What is Implicit and Explicit Measure1:59
Explore implicit and explicit measures in Power BI by showing how a product cost auto-sums, then contrast DAX-based explicit measures with automatically generated ones.

Section Introduction3:37
SUM3:52
MIN3:25
MAX1:47
Assignment - SUM, MIN, MAX0:33
Solution - SUM, MIN, MAX2:57
Create measures for total return quantity, min product price, and max product price using the sum, min, and max functions. Display each metric on a card with consistent formatting.
AVERAGE1:42
Assignment - AVERAGE0:39
Solution - AVERAGE2:30
COUNT1:50
DISTINCTCOUNT2:37
Learn how the distinct count function counts unique values in a column, and build a total customers in sales measure to show buyers by removing duplicates.
COUNTROWS1:52
Learn how count rows counts the number of rows in a specified table using the table name, with examples using the territories table and creating a measure total territories.
Assignment - COUNT, DISTINCTCOUNT, COUNTROWS0:49
Solution - COUNT, DISTINCTCOUNT, COUNTROWS3:00
Apply count and distinct count to build measures for total products, products in sales, and returned products. Use dimension and returns tables to reveal 293 total, 130 sold, 124 returned.

SUMX7:40
Assignment - SUMX0:47
Solution - SUMX0:50
MINX6:55
Learn how to use the MINX function to compute the minimum revenue across rows by evaluating price times quantity, with or without filter context, using measures versus calculated columns.
Assignment - MINX0:31
Create two measures: calculate total minimum cost by referencing the product cost and quantity, then derive minimum revenue by referencing the total cost measure.
Solution - MINX1:28
MAXX4:54
Apply the maxx function in dax to evaluate an expression across rows and within filter context, using price multiplied with quantity to identify maximum revenue.
Assignment - MAXX0:41
Solution - MAXX1:37
AVERAGEX4:23
Assignment - AVERAGEX0:27
Solution - AVERAGEX1:24
COUNTX3:14
Assignment - COUNTX0:13
Solution - COUNTX1:14
Assignment - Iterators1:50
Solutions - Iterators5:26

Section Introduction1:03
FILTER11:50
Learn how the dax filter function acts as an iterator that returns a table and enables precise filtering with calculate for regions, categories, and amounts.
Assignment - FILTER2:37
Solution - FILTER9:49
ALL10:38
ALLEXCEPT6:28
Use the all except function to remove all filters on a table except the specified columns, and apply it as a calculate modifier.
ALLSELECTED9:39
Assignment - ALL,ALLEXCEPT,ALLSELECTED2:09
Master DAX concepts all, allexcept, and allselected in a two-scenario assignment that replicates total revenue across countries and customers and counts products by country and customer.
Solution - ALL,ALLEXCEPT,ALLSELECTED3:50
Learn to build DAX measures that manage filter context with ALL, ALLEXCEPT, and ALLSELECTED, calculating revenue and country-specific product counts across a Power BI model.
Assignment - Filters Functions3:21
Solution - Filters Functions9:45

Section Introduction1:23
SELECTEDVALUE10:09
Learn the selected value function in DAX, which returns the value when a filter yields a single value and an alternate result otherwise, with cases in customers, regions, and months.
HASONEVALUE6:41
ISBLANK2:26
ISEVEN, ISODD2:03
Demonstrate how to use DAX ISEVEN and ISODD to determine if numbers are even or odd in Power BI, with examples on revenue and total return products, including blank values.
ISTEXT1:12
CONTAINSSTRING3:27
ISFILTERED2:35
ISINSCOPE4:04
Assignment - Information Functions1:28
Solution - Information Functions2:42

Requirements

Power BI Desktop (free download)
Power BI Desktop (not available on MAC OS)
No paid software required
Basic Power BI Knowledge would be plus bot Not required

Description

Dive into the world of Data Analysis Expressions (DAX) in Power BI with my comprehensive course, designed to take you from fundamentals to advanced techniques. This course is ideal for those who have a basic understanding of data connecting and transformation fundamentals in Power Query, as well as data modeling basics (no worries even you don't have fundamental knowledge of data transformation and modeling, I have covered Data transformation and modeling fundamentals to get started DAX).

Course Highlights:

Fundamentals covered : Refresh your knowledge on data connecting and transformation fundamentals in Power Query and data modeling essentials to ensure a strong foundation.
DAX Essentials: Understand the DAX engine, including row context and filter contexts, and explore calculated tables, calculated columns, and measures. Learn the differences between implicit and explicit measures.
Aggregation Functions: Master core DAX functions for aggregation such as SUM, MIN, MAX, AVERAGE, COUNT, DISTINCTCOUNT, and COUNTROWS.
Advanced DAX Techniques: Delve into CALCULATE functions, context transition, and the use of variables and measure tables for dynamic calculations.
Iterator Functions: Learn to apply iterator functions like SUMX, MINX, MAXX, AVERAGEX, and COUNTX to iterate over tables and perform complex calculations.
Filter Functions: Utilize filter functions including FILTER, ALL, ALLEXCEPT, and ALLSELECTED to manage and manipulate data contexts.
Information Functions: Explore functions like SELECTEDVALUE, HASONEVALUE, ISBLANK, ISEVEN, ISODD, ISTEXT, ISFILTERED, CONTAINSSTRING, and ISINSCOPE for effective data evaluation.
Logical Functions: Apply logical functions such as IF, AND, OR, SWITCH, and COALESCE to create robust and dynamic expressions.
Mathematical Functions: Use mathematical functions like ABS, VALUE, MOD, ROUND, and DIVIDE for precise calculations and transformations.
Text Functions: Master text manipulation with functions such as CONCATENATE, CONCATENATEX, LEFT, RIGHT, UPPER, LOWER, LEN, REPLACE, SUBSTITUTE, and FORMAT.
Table Functions: Learn to handle tables with functions like CALCULATETABLE, DISTINCT, VALUES, SUMMARIZE, ADDCOLUMNS, SELECTCOLUMNS, UNION, and GENERATESERIES.
Relationship Functions: Understand relationship functions such as RELATED, RELATEDTABLE, USERELATIONSHIP, and CROSSFILTER for managing data relationships.
Ranking and Top N: Implement TOPN and RANKX functions to rank and filter top results in your datasets.
Time Intelligence Functions: Master time-based calculations using DAX functions like TODAY, DATE, NOW, CALENDAR, and CALENDARAUTO. Learn to manipulate and analyze dates with functions such as YEAR, MONTH, QUARTER, WEEKNUM, and perform advanced time period calculations with TOTALYTD, TOTALQTD, TOTALMTD, DATESYTD, DATESQTD, DATESMTD, DATEADD, PARALLELPERIOD, SAMEPERIODLASTYEAR, DATESINPERIOD, EDATE, EOMONTH, PREVIOUSYEAR, PREVIOUSQUARTER, PREVIOUSMONTH, PREVIOUSDAY, NEXTYEAR, NEXTQUARTER, NEXTMONTH, NEXTDAY, STARTOFYEAR, STARTOFQUARTER, STARTOFMONTH, ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH, and DATEDIFF for comprehensive time-based analysis.
Calculation Groups: Learn how to create and manage calculation groups to streamline your DAX expressions and enhance reporting efficiency.
DAX Statements: Develop proficiency in writing and optimizing DAX statements for effective data analysis and reporting.
Visual Calculations: Enhance visualizations with calculations that include previous, next, first, last, collapse, expand, running sums, and ranges.

Additional Features:

Tricks and Tips: Discover practical tips and tricks to streamline your DAX calculations and improve efficiency.
Assignments: Apply your learning with hands-on assignments designed to reinforce key concepts and techniques.
Solution Walkthroughs: Review detailed solutions to assignments, gaining deeper insights and understanding to enhance your skills.

By the end of this course, you’ll be equipped with the skills to leverage DAX effectively for powerful data analysis and reporting in Power BI..

Who this course is for:

If you want to learn DAX from scratch
If you are a beginner and want to improve your problem solving skills in DAX
Even though this course is only DAX, have covered data transformation, data modeling fundamentals to get started

Complete DAX Bootcamp for Power BI from Beginner to Advanced

What you'll learn

Explore related topics

Course content

Introduction and Course Structure4 lectures • 4min

Data Connecting & Transformation - Prerequisite5 lectures • 23min

Data Model - Prerequisite5 lectures • 18min

DAX Started6 lectures • 11min

DAX - Aggregation Functions14 lectures • 31min

Context & Calculate, Variables, Tricks & Tips8 lectures • 37min

Iterator Functions17 lectures • 44min

Filters Functions11 lectures • 1hr 11min

Information Functions11 lectures • 38min

Logical Functions8 lectures • 50min

Requirements

Description

Who this course is for: