00:03 DAX is about data analysis expressions and using functions like sum, average, min, max, count, count rows, calculate, and filter. 02:23 Differentiating between measures and calculated columns 06:59 Understanding the difference between calculated column and measure 09:13 Power BI DAX functions make data manipulation simple 13:49 DAX is good at two things: aggregations and filtering. 16:14 Understanding and validating DAX measure assignments 20:32 Creating measures for minimum and maximum salary using DAX functions 22:52 Understanding different DAX functions 26:53 Power BI DAX functions for date and time analysis 29:15 Creating calculated tables and adding/subtracting dates in Power BI using DAX 33:15 Creating relationships between tables and adding new tables in Power BI 35:23 Creating a calendar table in Power BI for a specific date range and sorting the data based on month numbers. 39:24 Creating filter context in SQL and Power BI using calculate keywords. 41:29 Creating measures and filter context in Power BI DAX 45:47 Filtering a table using different methods 47:57 Understanding if-else and nested if blocks 52:20 Creating conditional columns in Power BI using DAX 54:38 Time intelligence functions help manipulate data using time periods. 58:47 Creating and understanding total year-to-date (YTD) in Power BI DAX 1:00:54 Explanation of Year to Date (YTD) concept 1:04:59 Using DAX measures for time intelligence in Power BI 1:07:00 Time intelligence functions for comparing previous and current values. 1:11:20 Reducing columns to optimize memory consumption. 1:13:25 Creating DAX expression for calculating total 1:18:12 Understanding the difference between average and average a in Power BI DAX 1:20:22 Using the x function saves memory and CPU utilization Crafted by Merlin AI.
I have understood these concepts earlier but somewhere I was lacking to learn it, now it's more clear bcz ur teaching style gives clarity on each topics. In today's class, I understood the implementation and application - why, where & when to use those concepts. Thanks a lot for this session... Love you❤🤟 God bless you
Thank you so much for the video. I am preparing for Power BI interview a guide would be helpful like what all we need to know means the topics and scenario. This was great video
It was really an awesome explanation on this topic!! It literally cleared my doubts, thankyou sir for such an amazing content! Please make more such videos on powerbi ;))
The content of this video is excellent and informative. We really appreciate the efforts you put into this. I have a doubt. In the 10:10 video, you are explaining the round function while converting months to years. When converting Months to years, it seems correct, but when you use the round values, they are different. Can you please check?
You mentioned AverageA includes other types of data in the column and while average ignores such records in Excel .. but in Power BI you mentioned Average and Average X both are same, we just use for memory usage and efficiency... I am unclear if Average X functions as AverageA in Excel as well ? I learnt a lot from this video, just need this clarification. GOOD WORK keep it coming
Very informative and useful video sir, appreciate your work 👏👏, please if you can make a detailed video on power query in PBI also, it will be great, thank you sir
Hi Satyajit, Thanks for this wonderful session. I have one doubt. At 51:45 , when you are calculating age bins, there is a row which has age 103, ideally the age bin should be "greater than 60". Why does it show 20-40?
@@SatyajitPattnaik Hi Satyajit, I'm still getting the same. Also, at 50:29 when you sorted Age in descending order, first record shows a person with age 706 which is not possible. When I opened the csv file in excel, max age I can find is 92. Not sure why in power BI it shows something weird. Am I missing something?
@@gauthama4092 Age might be getting summarized, click on the Viz, go to the fields, and click on Age and see if it is in Don't summarize mode or something else, must be a minor problem
@@RK-wf7re in interviews, you will given some industry level scenarios and real time issues or difficulties you faced in Power BI and how did you come over that, also focus on static/dynamic rls, dataflows etc
Very informative video, but while I was trying to practice ,in report view col name are coming as 'Sum of estimated salary' for all whole numbers and decimal numbers.
At vedio duration - 29.56 For DateAdd why there is Blank rows showing and what do u mean by the dates are not available? I mean how is this possible that dates are not available? Will be glad if u clear my doubts.
@@AmitKumar-ft9go oh sorry, I thought I answered. DateAdd basically will show those values that are in the range of the original Date column, infact that's how all Time Intelligence functions work.
bro superb i am also interested in teaching , can u guide how your recording and which softwer are using and editing can i know and mic part can u say just for growing my channel im asking
When i tried to pull columns to canvas why those columns are getting summarized with aggregate functions like sum, count etc. But in your demo its not happening, could you advise how to avoid summarization?
Did you go through the entire video? I hardly used the presentation for less than 5% of the entire time to show the DAX functions and then explained it on Power BI, pls go through the videos before commenting 😀
![Power BI DAX Tutorial - Beginner to Advanced [Full Course]](http://i.ytimg.com/vi/4rC9Ow76n0U/mqdefault.jpg)
![Beginner Power BI DAX Functions Tutorial [Full Course]](http://i.ytimg.com/vi/QJw4HkagVWc/mqdefault.jpg)
00:03 DAX is about data analysis expressions and using functions like sum, average, min, max, count, count rows, calculate, and filter.
02:23 Differentiating between measures and calculated columns
06:59 Understanding the difference between calculated column and measure
09:13 Power BI DAX functions make data manipulation simple
13:49 DAX is good at two things: aggregations and filtering.
16:14 Understanding and validating DAX measure assignments
20:32 Creating measures for minimum and maximum salary using DAX functions
22:52 Understanding different DAX functions
26:53 Power BI DAX functions for date and time analysis
29:15 Creating calculated tables and adding/subtracting dates in Power BI using DAX
33:15 Creating relationships between tables and adding new tables in Power BI
35:23 Creating a calendar table in Power BI for a specific date range and sorting the data based on month numbers.
39:24 Creating filter context in SQL and Power BI using calculate keywords.
41:29 Creating measures and filter context in Power BI DAX
45:47 Filtering a table using different methods
47:57 Understanding if-else and nested if blocks
52:20 Creating conditional columns in Power BI using DAX
54:38 Time intelligence functions help manipulate data using time periods.
58:47 Creating and understanding total year-to-date (YTD) in Power BI DAX
1:00:54 Explanation of Year to Date (YTD) concept
1:04:59 Using DAX measures for time intelligence in Power BI
1:07:00 Time intelligence functions for comparing previous and current values.
1:11:20 Reducing columns to optimize memory consumption.
1:13:25 Creating DAX expression for calculating total
1:18:12 Understanding the difference between average and average a in Power BI DAX
1:20:22 Using the x function saves memory and CPU utilization
Crafted by Merlin AI.
How do you extract this ?
I have understood these concepts earlier but somewhere I was lacking to learn it, now it's more clear bcz ur teaching style gives clarity on each topics. In today's class, I understood the implementation and application - why, where & when to use those concepts. Thanks a lot for this session... Love you❤🤟 God bless you
Thanks a lot for this comment 🔥🔥
It is Awesome. Waiting for your Advance and complex DAX calculation video.
Thanks for your dax video, Its very easy to understand.
Awesome way of teaching DAX .😊 We are waiting for your next video
Thank you so much for the video. I am preparing for Power BI interview a guide would be helpful like what all we need to know means the topics and scenario. This was great video
Thank you so much! for this lecture, So easy peasy method
It was really an awesome explanation on this topic!! It literally cleared my doubts, thankyou sir for such an amazing content! Please make more such videos on powerbi ;))
way of teaching amazing.tq sir
I was looking for same and finally you uploded it. Really Amazing Video. Keep Growing🙂
😎😎
The content of this video is excellent and informative. We really appreciate the efforts you put into this.
I have a doubt. In the 10:10 video, you are explaining the round function while converting months to years. When converting Months to years, it seems correct, but when you use the round values, they are different. Can you please check?
Very informative content, Thanks for the wonderful session!
I am glad you liked!! 🔥
Awesome! I like that you talk about and show examples from SQL and Python. Hope you keep it in your videos :)
Thae way of teaching is very impressive and reliable. could plz provide interview quation and answers as a pdf plz.
interesting n informative session. Thankyou sir...learnt many many things today in BI
I am glad you liked 🔥
53:52 - Time Intelligence
1:08:12 - X and nonX
Sharing data files with the videos may increase the understanding the contents and then practicing side by side, thanks
@@Sarfraz-r3e check description
Amazing video for beginers
You mentioned AverageA includes other types of data in the column and while average ignores such records in Excel .. but in Power BI you mentioned Average and Average X both are same, we just use for memory usage and efficiency... I am unclear if Average X functions as AverageA in Excel as well ? I learnt a lot from this video, just need this clarification. GOOD WORK keep it coming
Very informative video👏❤
Thank you sir for uploading it, it's really helpful.
Welcome
Hello Sir,
Could you also make a video on how to prepare for Pl-300 certification for Power BI beginners?
U better become pro at powerbi that's only how u can crack it.otherwise there is no chance of cracking it
Background music is annoying. Content is good.
Thanks 😊👍
Welcome 😊
Thank you for this video. It was really helpful. Can you also make a video on data modeling in power bi?
Yes can be done
Very informative and useful video sir, appreciate your work 👏👏, please if you can make a detailed video on power query in PBI also, it will be great, thank you sir
I already have a detailed end to end video, search power bi Satyajit, you will get it..
@@SatyajitPattnaik yes sir found the video 🙂
If I am Nurvous about Job then I saw your videos. Then I get confidence to start study
Such a huge compliment 🙏
Though it is very informatic, but at 9:56 48/12 is giving me 6 (Tenure in years) which seem incorrect. Have doubt
Hi Satyajit, Thanks for this wonderful session. I have one doubt. At 51:45 , when you are calculating age bins, there is a row which has age 103, ideally the age bin should be "greater than 60". Why does it show 20-40?
Not clearly visible, can you try the same and let me know if you are able to get the same problem or not
@@SatyajitPattnaik Hi Satyajit, I'm still getting the same. Also, at 50:29 when you sorted Age in descending order, first record shows a person with age 706 which is not possible. When I opened the csv file in excel, max age I can find is 92. Not sure why in power BI it shows something weird. Am I missing something?
@@gauthama4092 Age might be getting summarized, click on the Viz, go to the fields, and click on Age and see if it is in Don't summarize mode or something else, must be a minor problem
@@SatyajitPattnaik Sure. BTW this is an excellent tutorial. Thank you for this great video.
super video....if you have any full course ob power bi
I have most of the videos on my channel, for a more structured learning you can enroll my course , it costs INR 999/-
Thank you sir !!!
Welcome 🔥🔥
Awesome video just one feedback some places content was hiding by your picture.
super nice explanation.
At 9:09 the "Tenure" measure I created is not working for me. Error: Cannot find name ["Tenure"]. Some please help even though I have that column.
at 26:36
why you wrote AirPassengers[Month],Today(),year
why not AirPassengers[Year],Today(),year
It helps me to understand dax...one feedback please dont use bgm it distracts
In real time scenarios do we really need to create the tables in power bi level, because we will have all the required tables in backend right?
@@RK-wf7re in interviews, you will given some industry level scenarios and real time issues or difficulties you faced in Power BI and how did you come over that, also focus on static/dynamic rls, dataflows etc
Best option is to share the data set to practice along
@@RK-wf7re please check description of the video 😀
Very informative video, but while I was trying to practice ,in report view col name are coming as 'Sum of estimated salary' for all whole numbers and decimal numbers.
Sir pls made same video for SQL for data analyst means from beginning to advanced level
There's already a SQL video, check my playlists.
Plzz send the raw data set .... I want to practice...
At vedio duration - 29.56
For DateAdd why there is Blank rows showing and what do u mean by the dates are not available?
I mean how is this possible that dates are not available?
Will be glad if u clear my doubts.
Kindly reply something
@@AmitKumar-ft9go oh sorry, I thought I answered.
DateAdd basically will show those values that are in the range of the original Date column, infact that's how all Time Intelligence functions work.
Just imaging a scenario, if X is derived from Y, how can X have new values that are present in Y
bro superb i am also interested in teaching , can u guide how your recording and which softwer are using and editing can i know and mic part can u say just for growing my channel im asking
Very nice. Do you have example file to download? thanks
When i tried to pull columns to canvas why those columns are getting summarized with aggregate functions like sum, count etc. But in your demo its not happening, could you advise how to avoid summarization?
hi, Where Can i download the dataset...I am not able to find out in the description
Are u from Odisha
@@pritishparida29dec83 yes
@@SatyajitPattnaik Bhaina mote tike top 50 Dax functions kahibe jouta power bi re frequently use huye
Is it enough to get a job ? Or have to learn something?
It's enough
Could you provide the raw dataset what are you using in this video??
I don't have drill through option in power bi.I tried many times but failed.what to do please tell me
Pls provide the data set link which you used in this vedio
Can you help me with the link to download datasets
could you please provide the data for practice
i am niy able to set quality of the video.. can somebody pls help to set it upto 1080p or is it not avaiable for that format.
click on settings button, quality and advanced
Increase ur voice... Else shutdown the background noise
You need raise your voice loud enough otherwise you'll be successful
Thanks
kindly provide the Dataset Sir
43:19
kindly provide us the dataset
Screen is not clear, do the needful
background sound is not good
Turn on the cc’s
please dont put any music in your videos
This is a 2 year old video, I stopped putting music on my recent videos 😀
keep shut down background music
Background Music
Its not that crisp and clear... and I do not understand why you are using PDF to explain the concepts.
Did you go through the entire video?
I hardly used the presentation for less than 5% of the entire time to show the DAX functions and then explained it on Power BI, pls go through the videos before commenting 😀
Not clear
there is no need for that background music. already your microphone is not that good
Apologies
Plzz send the raw data set .... I want to practice...
Check description