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

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:
=============================

⏱ 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.

📺 More Power BI Videos on my Channel:
=================================

Previous concepts:

VIDEOS:

Power BI Playlists:

COURSES:

~

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

[saravanaDjoko]

Best Youtube channel for Power BI = 1. Chandoo
2. Data Tutorials.

[deepikaanjali]

00:04 Learn 80% of Practical Dax for data analysis and reporting
02:30 Understanding DAX language for PowerBI calculations
07:02 Creating a measure for total amount from shipments table
09:20 Creating and analyzing measures in PowerBI using DAX.
14:05 Understanding how total amount is an extra calculation on the data table.
16:20 DAX and Excel functions share a similar syntactical pattern but are two different things.
20:46 Understanding how DAX measure interacts with filter context in selecting specific product rows.
22:47 Understanding evaluation context in DAX calculations.
27:05 Composite calculation reveals insights using DAX measures
29:17 Measures in DAX don't belong to specific tables, but to the entire data model.
33:27 DAX enables powerful data analysis
35:36 Introduction to using DAX in PowerBI for analyzing sales data
39:42 DAX CALCULATE function can control evaluation context for versatile calculations
41:45 Demonstration of filtering and calculating with DAX in Power BI
45:57 Using DAX to calculate total amount for specific salespeople.
48:03 Using 'IN' clause in DAX similar to SQL for convenience
52:14 Using the IF function to compare two scalar values is crucial in DAX.
54:20 DAX measures need to return a single value, usually through aggregation or logical tests.
58:21 Tips for writing better Dax
1:00:39 Use smaller logical blocks while modeling in DAX instead of writing complex logic in one go.

[nikhilm]

The way you simplify the content .... is just at another level. You make it look like so simple, but its not until we do it practically 🙂. As you always say.... "Learn by doing".

[notchgeorge]

I love this man's teaching, he's part of my foundation as a beginner 3 years ago and I never stop referring to his videos whenever I need to sharpen up. Thanks Chandoo God bless you

[janmejayamishra]

Chandoo thanks for this video, I have been following you since starting of my career in this domain 8 years back... You are a genius in data analysis and go to person

[sukienve]

the analogy you use in the explanasion are beyond thank you for making these videos

[clintazotea]

CALCULATE was always hard for me to understand until someone said think of it as CALCULATE "IF"

[Be-PositiveEnjoy-Life]

I can only think of you as my mentor in my learning process. Your teaching style has given me a lot of confidence to grasp ideas more fully. You are the best!! ❤

[terihandrick]

Thank you again for always making it so easy to understand what is happening behind the scenes. I agree you are the BEST teacher on YT.

[曾皓楷-mg]

This is the best for learning power bi systematically

[akashchristopher]

the last "👍" "👎" trick I really liked it. awesome bro.❤

[karthikeyen.b]

Great Teaching Chando Sir...Saw from India in Tamilnadu 👍🔥

[pulkitsrivastava]

Chandoo Sir agar aapke videos nhi hote toh patani main kya krta. Itne paid courses kr liye but sirf aapke videos se samajh mein aaya thank you so much for creating such great content

[tackodiallo]

Great video. I have learned a lot. Thanks so much !

[johnborg]

Thanks Chandoo. I enjoyed this video!!!

[dibyajyotigoswami]

Wow.Great watch.Understood every single point.Crystal clear

[dannynedwich]

Another great video Chandoo, keep up the good work!

[RakshitDwivedi-pqqc]

You have a special skill of making anything interesting. 🔥 You are fhe reason i am a pro in Excel. Now looking forward to carry it on SQL and Power BI.

[CuriousJo]

Thank you! You are the best!!! "I will not make any more implicit measures!!!"

[Shoaibkhan-stl]

Chandoo Sir, Thank You and may God bless you.