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.
@ajityadav-db7qq2 жыл бұрын
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
@SatyajitPattnaik2 жыл бұрын
Thanks a lot for this comment 🔥🔥
@ujjwaltarway14382 ай бұрын
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
@user-pz5gs5kv8kАй бұрын
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 ;))
@shachendradubey79785 ай бұрын
It is Awesome. Waiting for your Advance and complex DAX calculation video.
@saidarao17505 ай бұрын
Thae way of teaching is very impressive and reliable. could plz provide interview quation and answers as a pdf plz.
@roronoazoro-5182 жыл бұрын
Hello Sir, Could you also make a video on how to prepare for Pl-300 certification for Power BI beginners?
@PraveenKumar-ic1to5 ай бұрын
U better become pro at powerbi that's only how u can crack it.otherwise there is no chance of cracking it
@anjalikesarwani497011 ай бұрын
Thanks for your dax video, Its very easy to understand.
@shubhammalode4733 Жыл бұрын
Awesome way of teaching DAX .😊 We are waiting for your next video
@juja281910 ай бұрын
Awesome! I like that you talk about and show examples from SQL and Python. Hope you keep it in your videos :)
@RK-wf7reАй бұрын
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?
@SatyajitPattnaikАй бұрын
@@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
@vishalbhattacharya6902 жыл бұрын
Very informative content, Thanks for the wonderful session!
@SatyajitPattnaik2 жыл бұрын
I am glad you liked!! 🔥
@PawanJaiwar-kg1lf Жыл бұрын
way of teaching amazing.tq sir
@ronylpatil2 жыл бұрын
I was looking for same and finally you uploded it. Really Amazing Video. Keep Growing🙂
@SatyajitPattnaik2 жыл бұрын
😎😎
@an_piya435811 ай бұрын
53:52 - Time Intelligence 1:08:12 - X and nonX
@shailshah99672 жыл бұрын
interesting n informative session. Thankyou sir...learnt many many things today in BI
@SatyajitPattnaik2 жыл бұрын
I am glad you liked 🔥
@eraofpoojasagar11 ай бұрын
If I am Nurvous about Job then I saw your videos. Then I get confidence to start study
@SatyajitPattnaik11 ай бұрын
Such a huge compliment 🙏
@divasukinkoblenz10 ай бұрын
Thank you for this video. It was really helpful. Can you also make a video on data modeling in power bi?
@SatyajitPattnaik9 ай бұрын
Yes can be done
@adistrail5 ай бұрын
It helps me to understand dax...one feedback please dont use bgm it distracts
@praveenkumarrai101 Жыл бұрын
Amazing video for beginers
@shikharsaxena89842 жыл бұрын
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
@SatyajitPattnaik2 жыл бұрын
I already have a detailed end to end video, search power bi Satyajit, you will get it..
@shikharsaxena89842 жыл бұрын
@@SatyajitPattnaik yes sir found the video 🙂
@RK-wf7reАй бұрын
Best option is to share the data set to practice along
@SatyajitPattnaikАй бұрын
@@RK-wf7re please check description of the video 😀
@jaypandey41012 жыл бұрын
Thank you sir for uploading it, it's really helpful.
@SatyajitPattnaik2 жыл бұрын
Welcome
@jaspreetsinghbrar20555 ай бұрын
Awesome video just one feedback some places content was hiding by your picture.
@soumighosh6726 Жыл бұрын
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.
@pranayranjan147Ай бұрын
Though it is very informatic, but at 9:56 48/12 is giving me 6 (Tenure in years) which seem incorrect. Have doubt
@RK-wf7reАй бұрын
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?
@roshankumar-br7of11 ай бұрын
super video....if you have any full course ob power bi
@SatyajitPattnaik11 ай бұрын
I have most of the videos on my channel, for a more structured learning you can enroll my course , it costs INR 999/-
@Gareeb_2 ай бұрын
Thanks 😊👍
@SatyajitPattnaik2 ай бұрын
Welcome 😊
@madhuparnadebnath90615 ай бұрын
Plzz send the raw data set .... I want to practice...
@SatyajitPattnaik5 ай бұрын
Check description
@piyushpathak73112 жыл бұрын
Sir pls made same video for SQL for data analyst means from beginning to advanced level
@SatyajitPattnaik2 жыл бұрын
There's already a SQL video, check my playlists.
@shraddhaverma41112 жыл бұрын
Thank you sir !!!
@SatyajitPattnaik2 жыл бұрын
Welcome 🔥🔥
@edchris6584 ай бұрын
Background music is annoying. Content is good.
@gauthama40922 жыл бұрын
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?
@SatyajitPattnaik2 жыл бұрын
Not clearly visible, can you try the same and let me know if you are able to get the same problem or not
@gauthama40922 жыл бұрын
@@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?
@SatyajitPattnaik2 жыл бұрын
@@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
@gauthama40922 жыл бұрын
@@SatyajitPattnaik Sure. BTW this is an excellent tutorial. Thank you for this great video.
@DishuMittal054 ай бұрын
Very informative video👏❤
@venkatexplorermetturdam11 ай бұрын
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
@anandramavarapu-pe7zv4 ай бұрын
super nice explanation.
@AmitKumar-ft9go2 жыл бұрын
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-ft9go2 жыл бұрын
Kindly reply something
@SatyajitPattnaik2 жыл бұрын
@@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.
@SatyajitPattnaik2 жыл бұрын
Just imaging a scenario, if X is derived from Y, how can X have new values that are present in Y
@timedeal1564Ай бұрын
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.
@amanahmed60572 жыл бұрын
at 26:36 why you wrote AirPassengers[Month],Today(),year why not AirPassengers[Year],Today(),year
@Akashavani72 жыл бұрын
Is it enough to get a job ? Or have to learn something?
@SatyajitPattnaik2 жыл бұрын
It's enough
@milar1786Ай бұрын
You need raise your voice loud enough otherwise you'll be successful Thanks
@arunavamukherjee75497 ай бұрын
Very nice. Do you have example file to download? thanks
@madhuparnadebnath90615 ай бұрын
Could you provide the raw dataset what are you using in this video??
@JahannaviSingh-wo7nz4 ай бұрын
could you please provide the data for practice
@shrihaan_shaurya5 ай бұрын
I don't have drill through option in power bi.I tried many times but failed.what to do please tell me
@himanshuvarshney46705 ай бұрын
Pls provide the data set link which you used in this vedio
@yagndabhi2178Ай бұрын
43:19
@pritishparida29dec83Ай бұрын
Are u from Odisha
@SatyajitPattnaikАй бұрын
@@pritishparida29dec83 yes
@pritishparida29dec83Ай бұрын
@@SatyajitPattnaik Bhaina mote tike top 50 Dax functions kahibe jouta power bi re frequently use huye
@KiranGunda-ph7df2 ай бұрын
Increase ur voice... Else shutdown the background noise
@user-wf5tc4qf6t4 ай бұрын
kindly provide the Dataset Sir
@priyaselvaraj4070 Жыл бұрын
Can you help me with the link to download datasets
@lokeshbatra3500 Жыл бұрын
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.
@SatyajitPattnaik Жыл бұрын
click on settings button, quality and advanced
@vismitasai25215 ай бұрын
kindly provide us the dataset
@vijayarana2087 Жыл бұрын
background sound is not good
@SatyajitPattnaik Жыл бұрын
Turn on the cc’s
@Fantikky4 ай бұрын
please dont put any music in your videos
@SatyajitPattnaik4 ай бұрын
This is a 2 year old video, I stopped putting music on my recent videos 😀
@pashaji59046 ай бұрын
Screen is not clear, do the needful
@optiontrading59515 ай бұрын
keep shut down background music
@famjam9544 ай бұрын
Not clear
@priyankaraut4726 Жыл бұрын
Background Music
@anjalitherkar74399 ай бұрын
Its not that crisp and clear... and I do not understand why you are using PDF to explain the concepts.
@SatyajitPattnaik9 ай бұрын
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 😀
@shitluna50kgonedogegogogo872 ай бұрын
there is no need for that background music. already your microphone is not that good
@SatyajitPattnaik2 ай бұрын
Apologies
@madhuparnadebnath90615 ай бұрын
Plzz send the raw data set .... I want to practice...