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
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?
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.
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 ;))
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
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
@@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.
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?
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
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)
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 🔥🔥
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
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?
Awesome way of teaching DAX .😊 We are waiting for your next video
Thanks for your dax video, Its very easy to understand.
It is Awesome. Waiting for your Advance and complex DAX calculation video.
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 ?
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 ;))
Awesome! I like that you talk about and show examples from SQL and Python. Hope you keep it in your videos :)
Thank you so much! for this lecture, So easy peasy method
way of teaching amazing.tq sir
Thae way of teaching is very impressive and reliable. could plz provide interview quation and answers as a pdf plz.
53:52 - Time Intelligence
1:08:12 - X and nonX
I was looking for same and finally you uploded it. Really Amazing Video. Keep Growing🙂
😎😎
Sharing data files with the videos may increase the understanding the contents and then practicing side by side, thanks
@@Sarfraz-r3e check description
Very informative content, Thanks for the wonderful session!
I am glad you liked!! 🔥
Amazing video for beginers
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.
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
interesting n informative session. Thankyou sir...learnt many many things today in BI
I am glad you liked 🔥
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
Thank you sir for uploading it, it's really helpful.
Welcome
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 🙂
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 video👏❤
Thanks 😊👍
Welcome 😊
Though it is very informatic, but at 9:56 48/12 is giving me 6 (Tenure in years) which seem incorrect. Have doubt
If I am Nurvous about Job then I saw your videos. Then I get confidence to start study
Such a huge compliment 🙏
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.
Background music is annoying. Content is good.
at 26:36
why you wrote AirPassengers[Month],Today(),year
why not AirPassengers[Year],Today(),year
super nice explanation.
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 🔥🔥
It helps me to understand dax...one feedback please dont use bgm it distracts
Best option is to share the data set to practice along
@@RK-wf7re please check description of the video 😀
Awesome video just one feedback some places content was hiding by your picture.
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
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.
hi, Where Can i download the dataset...I am not able to find out in the description
Is it enough to get a job ? Or have to learn something?
It's enough
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.
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
Very nice. Do you have example file to download? thanks
Plzz send the raw data set .... I want to practice...
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?
Are u from Odisha
@@pritishparida29-Dec-83 yes
@@SatyajitPattnaik Bhaina mote tike top 50 Dax functions kahibe jouta power bi re frequently use huye
I don't have drill through option in power bi.I tried many times but failed.what to do please tell me
Could you provide the raw dataset what are you using in this video??
43:19
Pls provide the data set link which you used in this vedio
could you please provide the data for practice
Can you help me with the link to download datasets
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
You need raise your voice loud enough otherwise you'll be successful
Thanks
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
kindly provide the Dataset Sir
kindly provide us the dataset
Increase ur voice... Else shutdown the background noise
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 😀
Screen is not clear, do the needful
Background Music
keep shut down background music
Not clear
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 😀
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