Learn 80% of DAX in an Hour (with FREE sample file) @chandoo_
Learn 80% of DAX in an Hour (with FREE sample file)  @chandoo_
Uploaded October 2024 | Updated November 2026, 6 hours ago
Want to learn DAX but don't have the time? This is the video for you. In this one-hour masterclass, learn the 80% essential DAX with practical examples. Understand and master concepts like:

โ†’ How to create measures ๐Ÿค”
โ†’ Measure vs. Column โš™
โ†’ Measure reusability โ™ป
โ†’ Evaluation Context ๐Ÿ’ป
โ†’ Basic DAX functions - SUM, COUNTROWS, AVERAGE, DIVIDE ๐Ÿงฎ
โ†’ Conditional DAX functions - IF ๐ŸŒฟ
โ†’ Understanding and using CALCULATE function ๐Ÿ“—
โ†’ Multiple filters with CALCULATE ๐Ÿฅ
โ†’ How to get good with DAX using ACMBU technique ๐Ÿ’ก

๐Ÿ“ Download practice workbooks:
=============================

Blank Power BI file (with data model + data) - chandoo.org/wp/wp-content/uploads/2024/10/powerbi-data-model-done.zip (unzip this)
Sample dataset - chandoo.org/wp/wp-content/uploads/2024/10/sample-chocolate-sales-data-all.xlsx

Completed Power BI file (and rest of the videos + files) - chandoo.org/wp/free-data-analyst-course

โฑ Video Chapters:
================
0:00 - Introduction to DAX & our data model
3:00 - Our first DAX measures
11:24 - Why we need DAX when you can get the same thing with "auto" calculations
13:18 - DAX Pledge (say it out with me ๐Ÿ—ฃ)
13:39 - Measure vs. Columns
15:08 - More DAX formulas
16:08 - Difference between Excel and DAX functions!
19:24 - Understanding Evaluation Context
25:12 - Reusing DAX measures
28:32 - Why not use table name in the measures?
30:56 - DIVIDE function
34:18 - CALCULATE function
42:21 - More than one filter with CALCULATE()
46:35 - IN operator
49:22 - Conditional logic with IF()
52:51 - Measures are SCALAR (Aggregates)
55:29 - Awesome DAX trick ๐Ÿ’ก
58:20 - ACMBU Technique for Better DAX ๐Ÿ˜Ž

๐Ÿ‘ฉโ€๐Ÿ’ป๐Ÿ‘จโ€๐Ÿ’ป Join my Power BI Course
==========================

Want to master all aspects of Power BI - right from Power Query to Data Modeling to Power Pivot to DAX to Visual design to Report building?
Then you are going to LOVE my Power BI Course.
Trusted by more than 1000 people all over the world and consistently rated 5* by everyone.

Check out the program and sign up today.
Go here ๐Ÿ‘‰ chandoo.org/wp/power-bi-course


๐Ÿ“บ More Power BI Videos on my Channel:
=================================

Previous concepts:

Data modeling: youtu.be/4ePNrdxWtY0
Introduction to Power BI: youtu.be/al4OfLIOl2w
Introduction to Power Query: youtu.be/MMdcczmULrU
Power BI Jargon Explainer - youtu.be/mO-fvZPg7-Q
Power BI Jargon Explainer (part 2) - youtu.be/6eQL_GnFXls

VIDEOS:

Power BI Sales Dashboard in an hour - youtube.com/live/mXD0Peot4hY?feature=share
Data analysis with Power BI (end to end live) - youtube.com/live/8tfcVnoEL0c?feature=share
Power BI end-to-end Course - youtu.be/uwe8C7K8fXY
Power BI + SQL how to - youtube.com/live/UQJAHUUFK-o?feature=share
How to use DAX (another video, just as awesome) - youtu.be/PQ5lALdFHCU
Complex Power BI Dashboard (end to end tutorial) - youtu.be/ooJO7NW4uJU

Power BI Playlists:

FREE Power BI Course - youtube.com/playlist?list=PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo
Power BI tips & examples - youtube.com/playlist?list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
Power BI DAX - youtube.com/playlist?list=PLmejDGrsgFyCm0i58VobdriBr--FA8lYh
Power BI Power Query - youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2


COURSES:

Power BI - chandoo.org/wp/power-bi-course
Adv. Excel - chandoo.org/wp/excel-school-program
Complete DATA Analysis course (Sql, Power BI, Excel, Python) - chandoo.org/mdac

~

CALCULATE(), FILTER() and ALL() wanted to have dinner together.
But it never happened.
Why?

Because FILTER() kept excluding people
ALL kept ignoring everything
and CALCULATE as usual was late ๐Ÿ˜‚

#Powerbi #dax #chandoo #freedataanalystcourse #fdac
Learn 80% of DAX in an Hour (with FREE sample file)Learn Excel COPILOT in just 15 minutes and Work Smarter ๐ŸคฏHow to make a Show / Hide SLICER PANEL in Power BI ๐Ÿ’กMake a beautiful and interactive To-Do List with Excel (Easy Tutorial ๐Ÿ‘Œ)Power BI Ecosystem - Explained in 25 minutesBecome an Excel PRO with this complete Dashboard Project ๐Ÿ“ˆYou dont need work email to use Power BI - Easy Fix ๐Ÿ˜ŽDONT tell my boss, but ChatGPT made this Excel dashboard ๐ŸคซHow to Split Names in Excel Super Fast!Calculate Employee Tenure Easily with this Formula Trick๐Ÿ’กLearn DAX ALL() Functions in Just 30 Minutes [POWER BI Essentials]Learn MS Access and Build your First Database Today
Chandoo |

Learn 80% of DAX in an Hour (with FREE sample file)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER