The way you simplify the content .... is just at another level. You make it look like so simple, but its not until we do it practically 🙂. As you always say.... "Learn by doing".
00:04 Learn 80% of Practical Dax for data analysis and reporting 02:30 Understanding DAX language for PowerBI calculations 07:02 Creating a measure for total amount from shipments table 09:20 Creating and analyzing measures in PowerBI using DAX. 14:05 Understanding how total amount is an extra calculation on the data table. 16:20 DAX and Excel functions share a similar syntactical pattern but are two different things. 20:46 Understanding how DAX measure interacts with filter context in selecting specific product rows. 22:47 Understanding evaluation context in DAX calculations. 27:05 Composite calculation reveals insights using DAX measures 29:17 Measures in DAX don't belong to specific tables, but to the entire data model. 33:27 DAX enables powerful data analysis 35:36 Introduction to using DAX in PowerBI for analyzing sales data 39:42 DAX CALCULATE function can control evaluation context for versatile calculations 41:45 Demonstration of filtering and calculating with DAX in Power BI 45:57 Using DAX to calculate total amount for specific salespeople. 48:03 Using 'IN' clause in DAX similar to SQL for convenience 52:14 Using the IF function to compare two scalar values is crucial in DAX. 54:20 DAX measures need to return a single value, usually through aggregation or logical tests. 58:21 Tips for writing better Dax 1:00:39 Use smaller logical blocks while modeling in DAX instead of writing complex logic in one go.
You have a special skill of making anything interesting. 🔥 You are fhe reason i am a pro in Excel. Now looking forward to carry it on SQL and Power BI.
Great one Chandoo.! Love the flexibility of DAX but only issue is when we build matrix using DAX measures, They are not drillable. They dont show underlining data behind the table. While the advantages include, This dont occupy much space and processing will be fast as we are not altering fact tables to add additional columns. Secondly, Dax could quickly run calculations as defend no matter how big is underlying data set.
None of the visuals allow such "drill" to data feature. But all of them have the ability to interact. So if you just want to see which rows (in the fact or elsewhere) correspond to a number in matrix (or any visual), just add a table. Whenever you click on the matrix number, the table just shows the data points for that value.
If you can please, do a dedicated video about real time project it would be really helpful and we can know where we are laging... And by the way I am from Andhra Telugu guy ... Hoping a thumb for this comment 🤍
Thanks for this suggestion. I have a few real-time project videos already on the channel (Power BI playlist - th-cam.com/play/PLmejDGrsgFyCqFbX3io5q8haeF7BUzWDP.html) Will add more.
Barr Bar March 2024 Sale = CALCULATE([Total Amount], people[Sales_person]= "Barr Faughny", products[Category] = "Bars", 'calendar'[year] = 2024, 'calendar'[month_name] = "March") Please correct me if am doing anything wrong.
![สั่งทอง.. จาก temu ของจริงป่ะ? ( part : 1/2 ) [โกงไหมครับ ep.94 ] | DOM](http://i.ytimg.com/vi/2tYS1qTMB78/mqdefault.jpg)
The way you simplify the content .... is just at another level. You make it look like so simple, but its not until we do it practically 🙂. As you always say.... "Learn by doing".
Best TH-cam channel for Power BI = 1. Chandoo
2. Data Tutorials.
Great Teaching Chando Sir...Saw from India in Tamilnadu 👍🔥
00:04 Learn 80% of Practical Dax for data analysis and reporting
02:30 Understanding DAX language for PowerBI calculations
07:02 Creating a measure for total amount from shipments table
09:20 Creating and analyzing measures in PowerBI using DAX.
14:05 Understanding how total amount is an extra calculation on the data table.
16:20 DAX and Excel functions share a similar syntactical pattern but are two different things.
20:46 Understanding how DAX measure interacts with filter context in selecting specific product rows.
22:47 Understanding evaluation context in DAX calculations.
27:05 Composite calculation reveals insights using DAX measures
29:17 Measures in DAX don't belong to specific tables, but to the entire data model.
33:27 DAX enables powerful data analysis
35:36 Introduction to using DAX in PowerBI for analyzing sales data
39:42 DAX CALCULATE function can control evaluation context for versatile calculations
41:45 Demonstration of filtering and calculating with DAX in Power BI
45:57 Using DAX to calculate total amount for specific salespeople.
48:03 Using 'IN' clause in DAX similar to SQL for convenience
52:14 Using the IF function to compare two scalar values is crucial in DAX.
54:20 DAX measures need to return a single value, usually through aggregation or logical tests.
58:21 Tips for writing better Dax
1:00:39 Use smaller logical blocks while modeling in DAX instead of writing complex logic in one go.
Barr amount , why not reflecting
Back on your video to revise DAXimportant must know ! You are awesome Chandoo😀
Thank you again for always making it so easy to understand what is happening behind the scenes. I agree you are the BEST teacher on YT.
Sir, Thank you for bring this DAX tutorial. Actually I was looking for a dedicated video for DAX in your chanel. It's very helpful.
You have a special skill of making anything interesting. 🔥 You are fhe reason i am a pro in Excel. Now looking forward to carry it on SQL and Power BI.
CALCULATE was always hard for me to understand until someone said think of it as CALCULATE "IF"
Great trick.
Thanks Chandoo. I enjoyed this video!!!
Glad you enjoyed it!
Thank you so much for educating how we should understand the concepts ❤
Thanks. Such an amazing teaching method. I will create a dashboard on this data, and you can see it by mentioning you in my linkedin post.
Best tutorials i ever come across 🎉
Great one Chandoo.!
Love the flexibility of DAX but only issue is when we build matrix using DAX measures, They are not drillable. They dont show underlining data behind the table.
While the advantages include, This dont occupy much space and processing will be fast as we are not altering fact tables to add additional columns. Secondly,
Dax could quickly run calculations as defend no matter how big is underlying data set.
None of the visuals allow such "drill" to data feature. But all of them have the ability to interact. So if you just want to see which rows (in the fact or elsewhere) correspond to a number in matrix (or any visual), just add a table. Whenever you click on the matrix number, the table just shows the data points for that value.
Thank you! You are the best!!! "I will not make any more implicit measures!!!"
😎😎😎
great as always❤
very insightful chandoo
Thank you its so helpful.i learnt lot
Awesome Chandoo!!!
Glad you enjoyed this Chris...
Thanks Chandoo. I enjoyed this video
Thank you Chandoo!
It's really helpful and easy to understand.You looks very handsome as well !
Thanks chandoo 🎉🎉
Namaste guruji from India 🙏
If you can please, do a dedicated video about real time project it would be really helpful and we can know where we are laging... And by the way I am from Andhra Telugu guy ... Hoping a thumb for this comment 🤍
Thanks for this suggestion. I have a few real-time project videos already on the channel (Power BI playlist - th-cam.com/play/PLmejDGrsgFyCqFbX3io5q8haeF7BUzWDP.html)
Will add more.
@@chandoo_ thanks for the reply will be waiting for your notification about projects in both channels Telugu and English
Must awaited video ❤❤❤
Sir superb sir ❤❤❤❤from india
Thank you!!!
Barr Bar March 2024 Sale = CALCULATE([Total Amount],
people[Sales_person]= "Barr Faughny",
products[Category] = "Bars",
'calendar'[year] = 2024,
'calendar'[month_name] = "March")
Please correct me if am doing anything wrong.
Sales Target 1 = 2000000
Sales Target 2 = 2250000
Sales Target 3 = 2500000
Star Rating = SWITCH(True,
[Total Amount]>[Sales Target 3],"⭐⭐⭐",
[Total Amount]>[Sales Target 2],"⭐⭐",
[Total Amount]>[Sales Target 1],"⭐",
"🔴")
Correct me this aswell.
Thank you so much sir
Thank you sir
Thanks
For Barr amount , box per shipment why my data not working it’s showing same
DAX is easy when you have a proper star schema
In real projects, you hardly have proper star schema 😢😅
@@TheAnalyticsEngine Totally agree
Power bi is ramp down in future? Last year I heard it. ??
Why would that happen?
@@abhinavtiwari4238 last year someone said power bi is going to retiring.. so.
Please explain telugu version also
👏👏
Need 20% remaining DAX
That will take another 1000 hours. That is the crazy part about DAX.
Answer to your assignment: $106K
💘
🎉
first comment😊😁
Very low level basic. I throught it covers 80% but not
Have you used DAX at all? This video offers a strong foundation and lays out the important aspects and mindset you need.
Your video has less learnings and more ads .Pathetic
Piss off... I don't decide the number and kind of ads. TH-cam does.