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.
Hello, Chandu Garu. I have been following your work for the past six months and have been consistently watching all your videos on Power BI. Would it be possible for you to create a video on SAP Analytics Cloud?
I can only think of you as my mentor in my learning process. Your teaching style has given me a lot of confidence to grasp ideas more fully. You are the best!! ❤
What a guy! Thanks a lot, Chandoo. This video was indeed incredibly helpful for me to kickstart my understanding of DAX. Even though I completed a few courses on Coursera, none of them actually introduced me to the concept of DAX, and those courses felt like boring sessions.
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.
Help !! I want to calculate team performance daily. Where Day starts 6am as shift changes and Week starts on Monday 6am and finish consecutive Monday 5:59. Dax formula please !!!
18:30 But once you see some functions - like CALCULATE() and DIVIDE(), you see that it isn’t as close to Excel formulas as you thought! It is very deceptive.
Anna...Data gathering, data cleaning, Eda, data modelling, analysis, visualization and reporting la step by step data analyst industrial work explain chestu oka project video chei anna. oka clearity vastadhi.
If you can make a video for beginners of dax formulas to explain the errors like syntax error, unexpected expression, etc. while creating dax formula s. Thanks
Sir can you create playlist for 'M'. There are hardly any good videos explaining the same. Also, anyone with good resource can please share the same. Thank You sir!!
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.
Barr bar Amount mar 2024 = CALCULATE([Total Amount], people[Sales_person]= "Barr Faughny", products[Category]="Bar" , 'calendar'[month_name]= "March", 'calendar'[year]= 2024). Even i have entered the same. i got blank values
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 - ruclips.net/p/PLmejDGrsgFyCqFbX3io5q8haeF7BUzWDP) Will add more.
But why you create a measure for showing total amount of product. It has already there amount filrer. So if we select amount filter can we get the total amount column?
Measures are for calculations. What you need is either a filter (to remove stuff) or Conditional formatting (to highlight stuff) For ex: Select the table and go to filter panel. Click on "filter on this visual" and add a filter to check if [Shipment Count] is greater than 5 This will remove any table rows with low shipment count.
Here’s the corrected text in English: I wonder if I really need to learn DAX or other programming languages when I can get help from AI. I understand that some aspects of data analytics, like data preparation, need to be done by me, but DAX? AI can write DAX formulas faster than I can... By the way, I know DAX, M, and Python, but since AI is widely available, I use it to get my job done faster.
AI can take you for a ride, if you don't know what you are doing. As you already know a lot, I think you are the right person to automate stuff with AI. That said, keep in mind that AI can still get things wrong, and it takes a keen eye and lots of skill to spot the mistakes.
Anyone can convey a message in a polite way not hurting others. His content and way of explanation is outstanding since years together. There are crazy fans for his teaching. So let’s concentrate on that. We came to learn let’s learn. Thanks Chandoo for your methods and teaching content.
![Digital Circus Episode 4 [TRAILER]](http://i.ytimg.com/vi/abZtsmMUbJo/mqdefault.jpg)
Best RUclips channel for Power BI = 1. Chandoo
2. Data Tutorials.
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.
Barr amount , why not reflecting
wonderful and crisp explanation of DAX.I liked how you broke down complex queries into small chunks of reusable code.
the analogy you use in the explanasion are beyond thank you for making these videos
Hello, Chandu Garu. I have been following your work for the past six months and have been consistently watching all your videos on Power BI. Would it be possible for you to create a video on SAP Analytics Cloud?
CALCULATE was always hard for me to understand until someone said think of it as CALCULATE "IF"
Great trick.
I can only think of you as my mentor in my learning process. Your teaching style has given me a lot of confidence to grasp ideas more fully. You are the best!! ❤
Thank you so much! Glad my videos help. 🙂
Great Teaching Chando Sir...Saw from India in Tamilnadu 👍🔥
What a guy! Thanks a lot, Chandoo. This video was indeed incredibly helpful for me to kickstart my understanding of DAX. Even though I completed a few courses on Coursera, none of them actually introduced me to the concept of DAX, and those courses felt like boring sessions.
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.
Hai,
Chandu garu, thanks a lot educating us with one hour master class with your easy explanation about DAX tutorial.
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.
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.
Thanks Chandoo. I enjoyed this video!!!
Glad you enjoyed it!
Another great video Chandoo, keep up the good work!
Excellent class explanation about DAX
Sirr!! You just squeezed three whole chapter from my book in a 1hr video. Great 🫡🫵🏻🫶🏻
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.
Back on your video to revise DAXimportant must know ! You are awesome Chandoo😀
Hi Chandoo, this is Superb, covered all fundamentals..
Requesting more videos like this 😊
Thank you so much for educating how we should understand the concepts ❤
Thank you! You are the best!!! "I will not make any more implicit measures!!!"
😎😎😎
Best tutorials i ever come across 🎉
very insightful chandoo
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.
@@chandoo_ Thanks very much!
Help !! I want to calculate team performance daily. Where Day starts 6am as shift changes and Week starts on Monday 6am and finish consecutive Monday 5:59. Dax formula please !!!
Thanks Chandoo. I enjoyed this video
2nd homework:-
Target Comparison = SWITCH(TRUE(),
[Total Amount]>250000, "⭐⭐⭐",
[Total Amount]>225000, "⭐⭐",
[Total Amount]>200000, "⭐",
"🚨")
1 zero kam lagaya hain apnay..baki DAX sahi hain
Target Comparision V4 =
IF(
[Total Amount]>2500000,"⭐⭐⭐",
IF(
[Total Amount]>2250000,"⭐⭐",
IF(
[Total Amount]>2000000,"⭐",
"🔴")))
thanks it worked , i tried in another way I got error
Awesome Chandoo!!!
Glad you enjoyed this Chris...
Thank you its so helpful.i learnt lot
18:30 But once you see some functions - like CALCULATE() and DIVIDE(), you see that it isn’t as close to Excel formulas as you thought! It is very deceptive.
It's really helpful and easy to understand.You looks very handsome as well !
how can we apply red colour for 'No' and green colour for 'yes'
57:06
26:36 Can you use the divide sign like that? I thought you had to use the DIVIDE() function! Thanks.
Thank you Chandoo!
You are the best ❤
Please give us practical knowledge for Microsoft Fabric
This is uuper helpful, thank you!
Namaste guruji from India 🙏
Anna...Data gathering, data cleaning, Eda, data modelling, analysis, visualization and reporting la step by step data analyst industrial work explain chestu oka project video chei anna. oka clearity vastadhi.
please make a video on customer Retention Rate and churn rate cohort analysis.
29:37 Can we create a hierarchical folder for all of our measures, so that they aren’t attached to a table, then?
Yes we can. I talk about measure organization in my portfolio project video here - ruclips.net/video/ooJO7NW4uJU/видео.html
thank you . we are blessed
If you can make a video for beginners of dax formulas to explain the errors like syntax error, unexpected expression, etc. while creating dax formula s. Thanks
Sir can you create playlist for 'M'. There are hardly any good videos explaining the same. Also, anyone with good resource can please share the same. Thank You sir!!
Thank you #Awesome Sir 🙏🏻😅.....
38:13 That’s nice, but how do you make it dynamic, by linking it to whatever salesperson is being selected on the slicer?
Thanks!
Use SELECTEDVALUE() to see the value picked by slicer.
Thanks a lot sir.
bro the last "👍" "👎" trick I really liked it bro . awesome bro.❤
Thanks. Glad you liked it.
Thanks chandoo 🎉🎉
Hi
could you please share how to make dynamic drill-through zoom charts.
great as always❤
Must awaited video ❤❤❤
Sir superb sir ❤❤❤❤from india
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.
Barr bar Amount mar 2024 = CALCULATE([Total Amount], people[Sales_person]= "Barr Faughny",
products[Category]="Bar" , 'calendar'[month_name]= "March", 'calendar'[year]= 2024). Even i have entered the same. i got blank values
Its bars not bar. Got it
@@anithasrimanimaran3369 Use FILTER function in between to filter
Use FILTER function in between to filter
Can we make a colum with DAX refering to a grouping column cretaed by grouping and binning in power bi? Please help
3:12 …And it stands for “Data Analysis eXpressions”
Bro, you are really awesome
Thanks....... DAX is a bit tough
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 - ruclips.net/p/PLmejDGrsgFyCqFbX3io5q8haeF7BUzWDP)
Will add more.
@@chandoo_ thanks for the reply will be waiting for your notification about projects in both channels Telugu and English
thanks alot!
Thank you so much sir
If I’m not wrong we use measure for data modelling which creates relation ship among the tables to create relationship
Measures are calculations, not used for creating relationships. That is done using the model view.
Thank you!!!
Thank you sir
But why you create a measure for showing total amount of product. It has already there amount filrer. So if we select amount filter can we get the total amount column?
is there any measure to weed out outliers like almond chocos(and eclairs and 50%darh bites) @34.13
Measures are for calculations.
What you need is either a filter (to remove stuff)
or Conditional formatting (to highlight stuff)
For ex:
Select the table and go to filter panel. Click on "filter on this visual" and add a filter to check if [Shipment Count] is greater than 5
This will remove any table rows with low shipment count.
Thanks
For Barr amount , box per shipment why my data not working it’s showing same
SQL for Data Analytics
Barr Bar March 2024 amt =
CALCULATE([Total Amount],
people[Sales_person] = "Barr Faughny",
'calendar'[month_name]="March",
'calendar'[year] = 2024)
Here’s the corrected text in English:
I wonder if I really need to learn DAX or other programming languages when I can get help from AI. I understand that some aspects of data analytics, like data preparation, need to be done by me, but DAX? AI can write DAX formulas faster than I can... By the way, I know DAX, M, and Python, but since AI is widely available, I use it to get my job done faster.
AI can take you for a ride, if you don't know what you are doing.
As you already know a lot, I think you are the right person to automate stuff with AI.
That said, keep in mind that AI can still get things wrong, and it takes a keen eye and lots of skill to spot the mistakes.
1st homework:-
Barr Bar Amount in MARCH 2024 = CALCULATE([Total_Amount], people[Sales_person]= "Barr Faughny", products[Category]="Bar", calendar[Month_name]="March", calendar[year]="2024")
hey did you get the output while I try to do this I'm getting issues
@@explorewithpk8984 no I haven't tried it yet...will run the query and inform you
Sir Data file / Excel file is not complete.
Please explain telugu version also
How to connect power bi to dynomodb
1st homework:-
Barr Bar Amount in MARCH 2024 = CALCULATE([Barr_Amount], products[Category]="Bar", calendar[Month_name]="March", calendar[year]="2024")
bro did it worked for you im facing issue
@@explorewithpk8984 Regarding?
awesome, awesome, thanks for your good video sir and nice initiative,but sorry to see your sad face,always want to see your bright face,thank you sir.
You are welcome. Why do you say sad face? I am happy as ever. May be lighting was a bit poor that day. 😂
When I am using slicer blank also added .I did try to remove blank but still blank here
Blank usually means either blank value in the data or missing (or incorrectly) set relationships.
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.
DAX is easy when you have a proper star schema
In real projects, you hardly have proper star schema 😢😅
@@govind_dataanalyst Totally agree
I will not make any more implicit measures
first comment😊😁
Answer to your assignment: $106K
👏👏
🎉
Need 20% remaining DAX
That will take another 1000 hours. That is the crazy part about DAX.
@@chandoo_💀
Not cover maximum numbers of dax functions
💘
Title change karke likh de Learn 0% of Dax in an hour ( with free useless sample file ) . Total waste of time 🙏
Fuck off man.. if you are so smart and already know everything what are you doing here.
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. RUclips does.
Anyone can convey a message in a polite way not hurting others. His content and way of explanation is outstanding since years together. There are crazy fans for his teaching. So let’s concentrate on that. We came to learn let’s learn. Thanks Chandoo for your methods and teaching content.