Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included)

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 - https://files.chandoo.org/pbix..../getting%20started%2

Completed Power BI File (with 20 DAX examples) - https://files.chandoo.org/pbix..../getting%20started%2

Raw Data file (Excel workbook) - https://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 - https://chandoo.org/wp/power-bi-play-date/


BOOK RECOMMENDATIONS 📚
==========================

Supercharge Power BI with DAX by Matt Allington - https://amzn.to/3HiPYEt
Definitive Guide to DAX by Marco Russo & Alberto Ferrari - https://amzn.to/3O9f4b6


More videos on Power BI & DAX 📺
=============================

Introduction to Power BI (45 minutes, 100k+ views) - https://youtu.be/uwe8C7K8fXY
Introduction to Power Query (80 minutes, 240k+ views) - https://youtu.be/PiFAa_jjaEI
Another video on DAX (live stream, 50k+ views) - https://youtu.be/eCuPRqQNe6Y

My Power BI Videos (playlist) - https://www.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