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 ;))

It is Awesome. Waiting for your Advance and complex DAX calculation video.

Thae way of teaching is very impressive and reliable. could plz provide interview quation and answers as a pdf plz.

Hello Sir, Could you also make a video on how to prepare for Pl-300 certification for Power BI beginners?

Thanks for your dax video, Its very easy to understand.

Awesome way of teaching DAX .😊 We are waiting for your next video

Awesome! I like that you talk about and show examples from SQL and Python. Hope you keep it in your videos :)

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?

Very informative content, Thanks for the wonderful session!

way of teaching amazing.tq sir

I was looking for same and finally you uploded it. Really Amazing Video. Keep Growing🙂

53:52 - Time Intelligence 1:08:12 - X and nonX

interesting n informative session. Thankyou sir...learnt many many things today in BI

If I am Nurvous about Job then I saw your videos. Then I get confidence to start study

Thank you for this video. It was really helpful. Can you also make a video on data modeling in power bi?

It helps me to understand dax...one feedback please dont use bgm it distracts

Amazing video for beginers

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

Best option is to share the data set to practice along

Thank you sir for uploading it, it's really helpful.

Awesome video just one feedback some places content was hiding by your picture.

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.

Though it is very informatic, but at 9:56 48/12 is giving me 6 (Tenure in years) which seem incorrect. Have doubt

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?

super video....if you have any full course ob power bi

Thanks 😊👍

Plzz send the raw data set .... I want to practice...

Sir pls made same video for SQL for data analyst means from beginning to advanced level

Thank you sir !!!

Background music is annoying. Content is good.

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?

Very informative video👏❤

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

super nice explanation.

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.

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

Is it enough to get a job ? Or have to learn something?

You need raise your voice loud enough otherwise you'll be successful Thanks

Very nice. Do you have example file to download? thanks

Could you provide the raw dataset what are you using in this video??

could you please provide the data for practice

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

43:19

Are u from Odisha

Increase ur voice... Else shutdown the background noise

kindly provide the Dataset Sir

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.

kindly provide us the dataset

background sound is not good

please dont put any music in your videos

Screen is not clear, do the needful

keep shut down background music

Not clear

Background Music

Its not that crisp and clear... and I do not understand why you are using PDF to explain the concepts.

there is no need for that background music. already your microphone is not that good

Plzz send the raw data set .... I want to practice...