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 - files.chandoo.org/pbix/gettin...
Completed Power BI File (with 20 DAX examples) - files.chandoo.org/pbix/gettin...
Raw Data file (Excel workbook) - files.chandoo.org/pbix/ac-sam...
⏱ 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-...
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 A...
Introduction to Power Query (80 minutes, 240k+ views) - • Power Query Tutorial -...
Another video on DAX (live stream, 50k+ views) - • Getting started with P...
My Power BI Videos (playlist) - • Beginner to PRO Data A...
~
What song do Data Analysts dance for?
DAX the way... aha aha
I Iike it... aha aha
😂
#PowerBI #dax

[@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

[@chandoo_]

Thanks EW.

[@manjunathmnm]

@@chandoo_ Chando greetings from Bangalore 👍 Wonderful video..

[@femiodunaye4456]

Nice one sir you are doing a good job

[@jankaufmann4305]

He's the talent explaining dry, complex things in an easy way. Truly what a teacher should do. Kudos to him.

[@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 🤩

[@mostafahosseini2872]

one of the best video training about "DAX"! thanks

[@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!

[@chandoo_]

You are welcome Frahaz. :)

[@ElCaminoHermano]

God bless your smart, generous and humble analytical soul!!

[@GurayVural-nz1lk]

You are an excellent instructor Chandoo! Very-well explained, step by step, and clear. Thanks a lot

[@dwaipayansaha4443]

One of the best explanation on DAX I came across. Thanks a lot Chandoo. Please keep making such videos

[@rakeshjalla4275]

You are really a good teacher, thank you.

[@isteaq993]

Can't stop myself of watching your video on Excel. Very useful & easy to understand. Can't thank you enough ❤

[@SunilKappal]

Chandoo is the best! I haven't seen and heard such an eloquent explanation of DAX methods. A big thanks for making such an amazing tutorial!

[@chandoo_]

My pleasure!

[@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

[@utubeAgape]

Love this! Thank you for providing the DAX measures for commonly used analysis. Helpful!

[@chandoo_]

You are welcome Irene... 😀

[@aniketwanjari2624]

@@chandoo_ chandoo sir i am from India.. Have some questions.. Can i share you on email.

[@KevinStudent]

OH MY GOD! The emoji shortcut/functionality is actually so awesome. Way better than the regular KPI icons!

[@azobensadio260]

it's amazing the way you teach power bi, you are the best!

[@BabsLee911]

You have a great channel and you're a great instructor/teacher. keep it up 👍

[@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

[@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.

[@khoihvm]

Thank you so much for your effort. The lesson is so clear and easy to understand.

[@ashokkumarpadmanabhan6483]

Really Amazing videos. I am learning daily with ease. Highly Appreciated your effort !!! Keep up your work

[@nadyamoscow2461]

You are just a fantastic tutor!! I really can`t thank you enough for your wonderful job.

[@jilalumustefa2276]

yes

[@lokeshagarwal6373]

Yes

[@sarthakmane2977]

This was really helpful, thank you very much!

[@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!

[@chandoo_]

Glad it was helpful!

[@sidindian1982]

Sir, the Wat you explained DAX & P-Pivot .. Mindblowing .. 🙂

[@zulumedia6374]

You are an excelent teacher. Thank you very much!

[@smaklad1]

Really one of the best foundation teaching I have ever seen. Thank you

[@chandoo_]

Glad it was helpful!

[@QuantuMatrix]

Epic and awesome Chandoo. Thanks for your time to deliver such an informative and practical learning opportunity to grasp power BI knowledge...

[@jayeshkumbhani1531]

It is really helpful for beginners.

[@Sreelalitha1903]

Awesome,very well explained👏👌

[@BSITVinluanEner]

smooth and well explain 🎉

[@ngwafabrice9561]

Chandoo has to he the best Tutor for power bi on this platform not even for his know how but especially how he simplifies everything he teaches❤❤❤ thanks alot

[@gayathri8234]

Thank you very much for this detailed video ..Clearly explained to the point 👍👍

[@nafeesahmed-zb1kj]

Superb Knowldge................. Thumbs UP........

[@abdulmd1083]

Chandoo you are such an amazing tutor. God bless you, keep rocking .

[@louplay]

Greetings from NZ, thanks for the tutorial - best one I've done so far!

[@chandoo_]

Great to hear!

[@AllinOne-kp8bp]

Thanks Chandooo. This video was very useful

[@nonoobott8602]

Great video and very explicit with good use cases. Thanks for sharing

[@chandoo_]

Thanks Nono. I am glad you enjoyed this.

[@ritwickgoswami8187]

You are amazing!!! Laughed my way to DAX!!

[@akin-ojoayotomide8909]

This was truly useful and helpful! Thank you

[@Hairy_MF_Steve]

Great vid. I'm happy I found it. It helps me do much.

[@prashantpareek8127]

Following your video so Deeply that gave you thumbs up the moment you said in the video

[@ihsansaleheen6672]

Just awesome sir. Thank You very much. Wish you all the best.

[@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)

[@louplay]

Yeah it's definitely 'Count of Products (right) = DISTINCTCOUNT(sales[Product])', so i wonder if the data in your table has been changed somehow, or if you have selected the wrong measure for your visualization

[@lightning369]

@@louplay Thanks for the concern. I will check it again.

[@nisaravi2140]

It has been useful for me to understand small small things from your way of presenting and how we can calculate it in a different ways . Actually I was confused to write the dax measures like I didn't even know the difference between same formulas in different formats. Thanks Chandoo keep posting videos related to power bi I am seriously looking for my path to becoming a dashboard star...

[@ginubaby1330]

Great video Chandoo. Well explained and very simple to follow for a beginner like me...

[@shashibhusanpandit7188]

Example of Filter and Calculator is awesome.

[@martinargimon730]

excellent and simple explanation. You are a great teacher. Thanks so much for your videos !!!. Take care !. Martin ( South Africa)

[@chandoo_]

You are welcome Martin 😀

[@gavidiharish13]

Only a master can explain like this🙌🙌🙌

[@Alan-wt1vo]

this just amazing and brilliantly explained

[@pradyumnakowsik]

Very well explained with lot of ease and simplicity in demonstration. Hope much more good helpful videos like this even in future.Tq

[@jephreyg-power310]

we love u somuch and more grace sir...Nigeria

[@nellier2155]

Your videos are epic. I have been adding myself to the waitlist for Power BI Play Date. Is shows reopen in Jan2021. Cant wait to attend the course.

[@keziahajah8808]

Thank you so much. This was awesome.

[@anilkumarsingh.3807]

chandoo ji, excellent explanation, your control on the content and way its been explained is just awesome

[@shyamdesai8944]

Hi Chandoo - Very good video. kept it simple but still very informative.

[@srinivaasadg]

This is great Chandoo, Simple and effective way of explaining Bang on😎 Keep Rocking

[@danielatitebi7062]

Fantastic Presentation, thanks in millions

[@dergimorka5341]

Thank you so much Chandoo really appritiated great job this is a very clear concept about the fundation of DAX

[@jamanemon2110]

This session was really very helpful for me chandoo. You are really a good teacher. Thank you so much for this video on DAX.

[@trishasingh8832]

The way you explain even the most complicated concepts is realllyyy BEAUTIFUL! Thank you for your efforts! ✨🇮🇳

[@chandoo_]

You are welcome Trisha 😀

[@Resh_aadil]

Thanks for detailing DAX Sir,great job,very useful

[@BenDieselBasicAutomotive]

Thank you very much, Idol. As always... I learned a lot...

[@richardjames7185]

Thank you so much. This has totally demystified the application (I had heard about it but not touched it) DAX is easy and very similar to PowerApps

[@meghanamags9217]

Great Job 😊 Love these videos and explanation

[@priyavishalkulkarni2415]

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👏💐

[@itstinku171]

hi can you clear one doubt in this video only when am calculating total amount of new zealand + australia countries am not getting correct values like in the video. Not understanding why am using variables even individual calculation also not getting correct results can you help?

[@samuelodoom2720]

Thank you so much sir. This is Gold

[@soroush5512]

Was Perfect man....thanks a lot!

[@sachinjagtap3220]

Great way of explaining, got to know about the fundamentals of DAX,,,, Thanks to your methods of teaching, it changed my perspective for DAX

[@chandoo_]

Glad to hear that

[@adewalem5474]

Thank you for the great tutorial sir!!!! really helpful

[@dubeypushpendra4558]

Dear Sir, You are ideal mentor. Thanks

[@chandoo_]

You are welcome Dubey 😀

[@jkumar8590]

Extraordinary. Pl do a video on time intelligence function too

[@parthasarathy4124]

You are a powerbi man bro, the property you use easily convey us concept clearly.thanks bro

[@chandoo_]

It's my pleasure

[@IswaryaMaran]

Amazing explanation .simple and neat

[@motivationendless6117]

Thanks Sir, these videos are truly very helpful.

[@user-ej3dh4kb1w]

I saw your vedio it is really great for basic level knowledge , i request you to please give advance level Dax formulas in future thank you very much

[@janhavikanthak5459]

This is very helpful!

[@arbazahmad7177]

Awesome 👌. Many thanks for this great lesson for DAX.

[@chandoo_]

My pleasure!

[@mohammedabdulhaseeb8897]

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

[@chandoo_]

Thanks Mohammed. DAX has been around since early 2010s. In fact, my oldest video on DAX on the channel was published in 2013! Better late than never.

[@shubhamjagtap1455]

Best video for knowledge ❤️❤️

[@magdahassib694]

Thank you very much, it is a very rich video

[@arvindr2101]

Great support. Thank you for all your super efforts.

[@chandoo_]

You are welcome Arvind.

[@pradeepreddy1308]

hi chandoo yur videos makes us to understnd in asimple way..thnku

[@adityasrivastava78]

Great Teaching !!!!

[@hendrag1174]

Great video, many thanks

[@dan.6398]

Truly big thank you

[@anv.4614]

Appreciated. Thanks

[@allwyncolaco3793]

Thank you so much 🙌🏻

[@kaltoumrachdi2086]

Thank you so much chandoo for this video

[@MindbodySync]

Dear Chandoo...big fan of your videos, hoping you get some sponsors soon😊

[@24x7fun21]

It's very helpful!

[@user-yl1fo5wy6q]

Thank you chandoo, You are awesome.

[@mrinaliniduttinnamuri4920]

Great Teaching!

[@darray7472]

Awesome! Jedi master Dax Chandoo!

[@bharathia8091]

Hello chandoo very interesting tutorial I am very much inspired by ur teachings and learning in every possible way.I want to restart my career in power bi pls help me to create a resume

[@GlamourdeeTv]

I wish I could buy you a gift. Thank you so much sir. Dora from Nigeria. I will refer my friends to your channel. You are blessed.

[@praaj4138]

Thanku so much for this video ❤️

[@rajeswararaosimma7976]

Your data analysis classes are very good. I have a doubt that how can we generate bulk number of notices for multiple attributes belongs one person. Is it possible in pivot table. Thank you sir.

[@asmmmoh2218]

Amazing❤❤❤ from cairo🎉🎉🎉🎉🎉

[@bharadwajvedula510]

Chandoo you are awesome Thank you

[@subashmurthy5981]

Chandoo we love you man... You are my go to whenever i face any issues in powerbi and this video is simply awwee.....

[@chandoo_]

Thank you Subhash 😍😍😍

[@subashmurthy5981]

@@chandoo_ Sending lots of love from India😍😍😍😍