DAX (Data Analysis Expressions) is the language used by Power Pivot (and Power BI) to build calculations and to analyze data. If you want to be good in Power BI, then you must learn DAX.
In this comprehensive video, learn how to get started and use DAX for many practical scenarios with 20+ examples.
What is covered?
==============
1️⃣ What is DAX & Power Pivot?
2️⃣ How to create and edit measures in Power BI?
3️⃣ Evaluation Context explained
4️⃣ Customizing the DAX measure display settings
5️⃣ Reusing DAX measures to build complex calculations
6️⃣ How to use CALCULATE() to change the "FILTER" criteria
7️⃣ DAX Measures vs. Columns
8️⃣ Using Variables in DAX
9️⃣ OR conditions, IN operator in DAX
🔟 DAX tips & guidance to improve your skills
SAMPLE WORKBOOKS 📂
=====================
Blank Power BI File (with data model) to follow along - files.chandoo.org/pbix/getting%20started%20with%20dax.pbix
Completed Power BI File (with 20 DAX examples) - files.chandoo.org/pbix/getting%20started%20with%20dax-full.pbix
Raw Data file (Excel workbook) - files.chandoo.org/pbix/ac-sample.xlsx
⏱ Video Topics 👇
================
0:00 - What is DAX & Power Pivot?
2:10 - Our first DAX measure
4:46 - Understanding the Power Pivot Calculation Engine & Evaluation Context
7:10 - Formatting the DAX measures
11:32 - Reusability of DAX measures
18:29 - IF Condition in DAX
25:27 - DISTINCTCOUNT in DAX
31:05 - MIN / MAX / AVERAGE
31:42 - CALCULATE in DAX
41:11 - Adding columns with DAX
45:03 - Alternate syntax for CALCULATE()
46:10 - Variables in DAX
48:36 - OR Conditions in DAX (with CALCULATE)
49:45 - 20 DAX measures (recap)
51:48 - How to learn more DAX?
LEARN MORE about DAX 💻💡
========================
My Power BI Course - chandoo.org/wp/power-bi-play-date/
BOOK RECOMMENDATIONS 📚
==========================
Supercharge Power BI with DAX by Matt Allington - amzn.to/3HiPYEt
Definitive Guide to DAX by Marco Russo & Alberto Ferrari - amzn.to/3O9f4b6
More videos on Power BI & DAX 📺
=============================
Introduction to Power BI (45 minutes, 100k+ views) - youtu.be/uwe8C7K8fXY
Introduction to Power Query (80 minutes, 240k+ views) - youtu.be/PiFAa_jjaEI
Another video on DAX (live stream, 50k+ views) - youtu.be/eCuPRqQNe6Y
My Power BI Videos (playlist) - youtube.com/watch?v=uwe8C7K8fXY&list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
~
What song do Data Analysts dance for?
DAX the way... aha aha
I Iike it... aha aha
😂
#PowerBI #dax
- Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included) ( Download)
- 📊 How to use Power BI DAX - Tutorial ( Download)
- Power BI DAX Tutorial | How to use DAX functions with Examples | Beginners | Power BI Tutorial ( Download)
- Beginner Power BI DAX Functions Tutorial [Full Course] ( Download)
- Beginner to PRO Data Analysis with Power BI - Full Length Course (with sample files!) ( Download)
- Mastering DAX Functions and Power Pivot for Power BI with 20 Beginner to PRO Examples #powerbi #data ( Download)
- Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡ ( Download)
- Power BI Tutorial For Beginners | Create Your First Dashboard Now (Practice Files included) ( Download)
- What! We don't need to learn DAX anymore (New Power BI Feature) ( Download)
- Master Power BI Essentials in Just 15 minutes ( Download)
- Power BI Dashboard for Beginners - COMPLETE MASTERCLASS (with sample file 📁) ( Download)
- I don't use PIVOT tables anymore... I use this other thing instead! ( Download)
- ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024) ( Download)
- Power BI DAX Tutorial - Beginner to Advanced [Full Course] ( Download)
- Full Free DAX Class: Fundamentals of DAX in Power BI & Power Pivot. 365 MECS Class 17 ( Download)
