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

352,340
0
Published 2022-06-14
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%20…

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

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) -    • Beginner to PRO Data Analysis with Po...  
Introduction to Power Query (80 minutes, 240k+ views) -    • Power Query Tutorial - What is it, ho...  
Another video on DAX (live stream, 50k+ views) -    • Getting started with Power Pivot & DA...  

My Power BI Videos (playlist) -    • Beginner to PRO Data Analysis with Po...  

~

What song do Data Analysts dance for?

DAX the way... aha aha
I Iike it... aha aha
😂

#PowerBI #dax

All Comments (21)
  • @excelworx8712
    This is a truly EPIC video Chandoo. I have not seen anyone covering DAX measures like this. You should make a video about some advanced measures now
  • @happyshoe1
    This is SO GOOD! Chandoo, your videos have been invaluable in my learning Power BI. Years ago I worked extensively with Hyperion Essbase and IBM Cognos TM1. I’m astonished with the power of Power BI.
  • @TataNaresh
    The way chandoo teaches is flawless.Trainer explains the concepts in a smooth and simple way 🤩
  • One of the best explanation on DAX I came across. Thanks a lot Chandoo. Please keep making such videos
  • @Farhazh
    Thank you sooo much Chandoo! This is what i was looking for since forever! No one can explain as clearly as you do, much appreciated!
  • @ayeshaakter1710
    Just giving Thanks is not enough for this excellent tutor "MR.Chando". Its SOOOO GOOD indeed. I 'm an OCP. Keep going on Sir.
  • @GurayVural-nz1lk
    You are an excellent instructor Chandoo! Very-well explained, step by step, and clear. Thanks a lot
  • I'm practicing for Power BI from last month. From first day I'm following your videos. It's so clear and easy to understand. Keep rocking Sir👏💐
  • @jkumar8590
    Extraordinary video. Quality video. Quality audio. Quality content. Your video removed fear associated with Dax. I suggest that your courses may be priced reasonably so that more people can benefit without any loss to you. Please consider
  • @isteaq993
    Can't stop myself of watching your video on Excel. Very useful & easy to understand. Can't thank you enough ❤
  • @user-ju5hz5ok1t
    I am using power bi few days ago this video is very good and helpful to learn and easily guide the common used DAX measure analysis
  • @QuantuMatrix
    Epic and awesome Chandoo. Thanks for your time to deliver such an informative and practical learning opportunity to grasp power BI knowledge...
  • @BabsLee911
    You have a great channel and you're a great instructor/teacher. keep it up 👍
  • @diyapatel4446
    this is an excellent, easy to understand and to the point tutorial and a very friendly introduction to DAX. thank a ton for this tutorial!
  • @utubeAgape
    Love this! Thank you for providing the DAX measures for commonly used analysis. Helpful!
  • @lightning369
    This is purely an exceptional and excellent talent you have in training, Chandoo. I am impressed by the ease of digesting your content. It is above and beyond. I am enjoying doing the hands-on as you walk me through using your datasets. At timestamp 27th minute, I am having a snag case in getting the correct count. I am just getting all these 22s. I have used 3 formulae with the third one getting from someone in the comments but none gives give the correct distinct count. The cardinality in my ERD (let me call it so) of the relationship is "Products" to "Sales" as 1 to Many just like yours. I downloaded the recent Power BI desktop in case it is a difference in versions that may use different formulae to achieve the correct results. I don't know where I am wrong. I tried every one of these DAX formulae. Count of Products1 = COUNTROWS(products) Count of Products (right) = DISTINCTCOUNT(sales[Product]) Distinct Products Count = CALCULATE( COUNTROWS(products),sales)
  • @MAH8897
    Hello Chandoo, It is wonderful to see your Tut, it is give me a mood to go back in my past, as I worked in Saudi in SAP ERP in most modules, during that time DAX was not their, now I use imagination how good it was if you and DAX was there. Any how your kind efforts really helps me in learning new things and brushes up knowledge, and same shareing with my son's. Almighty bless you and your family. Love from Hyderabad