Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included)
ฝัง
- เผยแพร่เมื่อ 28 มิ.ย. 2024
- 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 - วิทยาศาสตร์และเทคโนโลยี
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
Thanks EW.
@@chandoo_ Chando greetings from Bangalore 👍 Wonderful video..
Nice one sir you are doing a good job
He's the talent explaining dry, complex things in an easy way. Truly what a teacher should do. Kudos to him.
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.
The way chandoo teaches is flawless.Trainer explains the concepts in a smooth and simple way 🤩
Just giving Thanks is not enough for this excellent tutor "MR.Chando". Its SOOOO GOOD indeed. I 'm an OCP. Keep going on Sir.
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!
You are welcome Frahaz. :)
One of the best explanation on DAX I came across. Thanks a lot Chandoo.
Please keep making such videos
You are an excellent instructor Chandoo! Very-well explained, step by step, and clear. Thanks a lot
God bless your smart, generous and humble analytical soul!!
one of the best video training about "DAX"!
thanks
Can't stop myself of watching your video on Excel. Very useful & easy to understand.
Can't thank you enough ❤
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
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
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👏💐
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?
You can try this it worked for me, go to data modeling tab and link one table of the columns to the other table column which is of same Dat type , then try adding it will work
it's amazing the way you teach power bi, you are the best!
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!
Glad it was helpful!
Love this! Thank you for providing the DAX measures for commonly used analysis. Helpful!
You are welcome Irene... 😀
@@chandoo_ chandoo sir i am from India.. Have some questions.. Can i share you on email.
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!
My pleasure!
OH MY GOD! The emoji shortcut/functionality is actually so awesome. Way better than the regular KPI icons!
You are just a fantastic tutor!! I really can`t thank you enough for your wonderful job.
yes
Yes
Thank you so much for your effort. The lesson is so clear and easy to understand.
Sir, the Wat you explained DAX & P-Pivot .. Mindblowing .. 🙂
Really one of the best foundation teaching I have ever seen. Thank you
Glad it was helpful!
Best explanation for the DAX.
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
You have a great channel and you're a great instructor/teacher. keep it up 👍
You are amazing!!! Laughed my way to DAX!!
You are an excelent teacher. Thank you very much!
You are really a good teacher, thank you.
Really Amazing videos. I am learning daily with ease. Highly Appreciated your effort !!! Keep up your work
Great video and very explicit with good use cases. Thanks for sharing
Thanks Nono. I am glad you enjoyed this.
The way you explain even the most complicated concepts is realllyyy BEAUTIFUL!
Thank you for your efforts! ✨🇮🇳
You are welcome Trisha 😀
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
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.
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)
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
@@louplay Thanks for the concern. I will check it again.
Chandoo you are such an amazing tutor. God bless you, keep rocking .
Greetings from NZ, thanks for the tutorial - best one I've done so far!
Great to hear!
Thank you very much for this detailed video ..Clearly explained to the point 👍👍
This was truly useful and helpful! Thank you
Only a master can explain like this🙌🙌🙌
Epic and awesome Chandoo. Thanks for your time to deliver such an informative and practical learning opportunity to grasp power BI knowledge...
Example of Filter and Calculator is awesome.
Following your video so Deeply that gave you thumbs up the moment you said in the video
excellent and simple explanation. You are a great teacher. Thanks so much for your videos !!!. Take care !. Martin ( South Africa)
You are welcome Martin 😀
Just awesome sir. Thank You very much. Wish you all the best.
Thank you very much, Idol. As always... I learned a lot...
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...
This was really helpful, thank you very much!
this just amazing and brilliantly explained
we love u somuch and more grace sir...Nigeria
This session was really very helpful for me chandoo. You are really a good teacher. Thank you so much for this video on DAX.
Great way of explaining, got to know about the fundamentals of DAX,,,, Thanks to your methods of teaching, it changed my perspective for DAX
Glad to hear that
Fantastic Presentation, thanks in millions
Thank you so much Chandoo really appritiated great job this is a very clear concept about the fundation of DAX
Thanks for detailing DAX Sir,great job,very useful
Great vid. I'm happy I found it. It helps me do much.
You are a powerbi man bro, the property you use easily convey us concept clearly.thanks bro
It's my pleasure
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
Awesome tutorial Chandoo..You are a great teacher. Thanks a lot
Very well explained with lot of ease and simplicity in demonstration. Hope much more good helpful videos like this even in future.Tq
Thanks Sir, these videos are truly very helpful.
Great video Chandoo. Well explained and very simple to follow for a beginner like me...
Great Job 😊 Love these videos and explanation
It is really helpful for beginners.
Awesome 👌. Many thanks for this great lesson for DAX.
My pleasure!
Great support. Thank you for all your super efforts.
You are welcome Arvind.
Thank you so much sir. This is Gold
Thank you for the great tutorial sir!!!! really helpful
Thank you so much. This was awesome.
Was Perfect man....thanks a lot!
Dear Sir,
You are ideal mentor.
Thanks
You are welcome Dubey 😀
Hi Chandoo - Very good video. kept it simple but still very informative.
chandoo ji, excellent explanation, your control on the content and way its been explained is just awesome
This is great Chandoo, Simple and effective way of explaining Bang on😎 Keep Rocking
Amazing explanation .simple and neat
Superb Knowldge................. Thumbs UP........
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.
hi chandoo yur videos makes us to understnd in asimple way..thnku
Thank you very much, it is a very rich video
Hii sir its really fantastic video for freshers . Iam really excited to say wahh taj. No more words to explain and after completing this video iam very confident about DAX
All the best
Brilliant as always. I had to share this video.
Thanks Lilian :)
This was fantastic, thanks Chandoo!
Glad you liked it Chris :)
Best video for knowledge ❤️❤️
Thanks Chandooo. This video was very useful
Great video, many thanks
Thank you so much chandoo for this video
Thank you chandoo, You are awesome.
Another great video! Thanks 🙏.
Glad you enjoyed it!
Appreciated. Thanks
Extraordinary. Pl do a video on time intelligence function too
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
Awesome!
Jedi master Dax Chandoo!
Hi Bro, Thanks for your valuable time and effort for us. Keep rocking it.
You are welcome Praveen. Don't forget to share your knowledge with others by helping a colleague / friend when they need you.
Another excellent videos!
This is very helpful!
Thank you so much 🙌🏻
very useful, thank you so much
Chandoo you are awesome
Thank you
Great Teaching !!!!
Thanks a lot for gods work
Truly big thank you
Awesome,very well explained👏👌