[[ 3 HOURS ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - { End to End } Full Course

▬▬▬▬▬▬▬▬ POWER BI - DAX - FULL COURSE ▬▬▬▬▬▬▬▬
1) 00:00 - What is there in this video
2) 02:03 - DAX Topics
3) 03:47 - Introduction to DAX
4) 05:30 - Measure /Calculated Column /Calculated Table
5) 13:35 - DAX Fundamentals
Syntax , Naming, Operators, Data Types
6) 18:37 - DAX Basics Demo
7) 42:10 - How DAX Works
Filter context vs Row context
Calculate (Magician)
8)1:07:06 - Types of DAX Functions
9) 1:09:00 - Most Used DAX Functions
10) 1:12:25 - Aggregate Functions
11) 1:32:16 - Date & Time Functions
12) 1:41:12 - Time Intelligence Functions
13) 1:59:15 - Filter Functions
15) 2:11:39 - Logical Functions
14) 2:31:54 - Relationship Functions
16) 2:49:49 - Text Functions
17) 2:55:26 - Summary
Source Database
How To install Adventure works.
• How to Restore Adventu...
#PowerBI #DAX #POWERBIDAX
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬
Telegram Channel - t.me/analyticswithnags
Linkedin Page - / analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Data Warehouse Tutorials 📚📖 • Introduction | Data Wa...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
SSIS Tutorials - SQL Server Integration Services 📚📖 • Introduction to SQL Se...
Power BI Interview Topics 📚📖 • What to Expect in Powe...
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 • What to Expect in MSBI...
Excel for Data Analysis 📚📖 • Analytics with Nags Yo...
Power BI + R 📚📖 • Analytics with Nags Yo...
Azure for Analytics - Complete Tutorials 📚📖 • Analytics with Nags Yo...
Catch with Nags 📚📖 • Catch Up With Nags - I...
Nags Checklist 📚📖 • 5 Things to Consider w...
Visuals with Nags 📚📖 • Visuals With Nags - Intro

[@satyadevi936]

Thank you so much for content, you really understand what people need and you are trying to help them with your teaching it's very good quality in you.. whoever asks me about power bi or relevant skill set without thinking I directly come to your channel and share with them.. thankyou 🙏

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@andersonaraujo1992]

I really appreciate all you efforts to make this public high quality course. It's such an amazing channel!! congratulations!!

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues. If you are in LinkedIn talk about this channel

[@neilparsons9221]

Thanks so much for this Nags. I've been struggling to get my head around DAX for a long time. This video really helps put it all into context and I think I'm finally starting to learn how to use it. 👍

[@AnalyticswithNags]

Thanks keep learning learning. Share this channel with friends and colleagues

[@Sanam7]

Warm thanks to you Naga sir for this wonderful, useful, point to point video on DAX for quick understanding or revision of this subject. This is my second video course from your channel after end to end sql course. Much thanks and love. 🙏

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@mannykhan7752]

Hi Nags thank you so much for posting this video. It would've taken you a long time and effort to research and prepare material in this video for which I am very grateful. The fact that you decided to make this video free for everyone speaks volumes about your character. Stay blessed and keep on posting more good videos like this.

[@AnalyticswithNags]

That’s true. It took long time. Keep learning share this channel with friends and colleagues

[@Rafian1924]

Huge respect Nags.

[@nishachaware1044]

True

[@yogeshpatole9595]

@@AnalyticswithNags sir AdventuresWorkDW " where are that file

[@HM70777]

@@yogeshpatole9595 yes. Not able to find.

[@naresh71124]

Thanks for the video Nags. Appreciated for your efforts to make these kind of End to End videos. If possible please do a video on Performance optimisation.

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues.
Sure will make it soon

[@RockyRocky-vz7su]

Thanks for posting this video. Explained and demonstrated with clear understanding. Waiting for some material like this. I have gone through other DAX posts but not satisfied with explanation. You are on Next Level bro.... Spending Many hours to prepare this material and share the knowledge with others is not easy..... Keep posting

[@AnalyticswithNags]

Thanks keep learning

[@naveendintakurthi8032]

Hi Nag thank you so much for this tutorial. It has given an overview of all types of DAX functions. I am looking forward to learn much more advanced DAX tutorials from you. Thanks for this great work.

[@AnalyticswithNags]

Glad it was helpful!

[@Bold_Experience]

This is one of the best you can ever have understanding DAX, Thanks Nags for this great work

[@AnalyticswithNags]

My pleasure!

[@priyashome887]

I was trying to understand DAX for past 1 week. Finally I found this. It's really really clear and amazing. Thanks a lot!

[@AnalyticswithNags]

Thanks keep learning share this change with friends and colleague

[@runilkumar5807]

Really helpful. Thanks for providing this. I like your approach of explaining. Thanks once again 🙏🏻

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@risan.]

Thanks for the video Nas! This really helped me logically understand usecases of all basic functions.

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@lavanya.v125veeravalli4]

Thank you nag ji thank a lot for you're wonderful explanation for the hardest topics to understand..
You made it easier with you're explanation..

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@sivakumarvarma1401]

I appreciate you effort in explaining PowerBI DAX very understandable manner, please continue this.

[@AnalyticswithNags]

Thanks keep learning

[@mohamedkasim5534]

I appreciate the effort put in to make this video. It was really helpful to understand the concept and usage of the DAX. Thank you.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@javeedsjb]

Awesome! Saw your video and it made me to subscribe your channel. You are doing wonderful job. Thank you very much for guiding the learners without cost...

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues. If you are in LinkedIn shout out about this channel

[@sattimama]

Nice video, with all important DAX functions compiled together.

[@AnalyticswithNags]

Thanks keep learning

[@asrithap2134]

Thank you so much for taking time and bringing in such useful videos..

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@KapilSharma-1989]

I feel blessed to have such Cristal explanation

[@rahulkushwaha6469]

Heavy Respect sir..
Must watch videos if we are starting or even if we know Power BI.
Learnt a lot .
Thank you again.

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@rahulkushwaha6469]

@@AnalyticswithNags sure sir .

[@யாழ்குறும்பு]

Great... Thank you very much for this video. This video effectively tells how I learn DAX step by step. It took 2 days to complete these videos (In my mind, I wonder how long it would have taken you to create this video if it were you? ). It's a good initiation for me to DAX learning. Thank you :)

[@AnalyticswithNags]

It took total 20 hours (4 weekends )

[@aniketwanjari2624]

​@@AnalyticswithNags where can i put question. Any email. I'd?
Have a question on datediiff

[@joginapallyvivek398]

You have a great Patience - Lot of thanks - May God bless you in every aspect to move ahead towards your desires

[@AnalyticswithNags]

Thank you so much!

[@ootec1]

Hi Naga, I learned lot of things with this video. Its very helpful. Even its a long video I suggest everyone to watch this one short will get knowledge on complete DAX.

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@sameerkale7282]

Thank you so much sirji for your end to end video of DAX 👌🙏

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@ingridgwladys2827]

Wow I am actually impressed and grateful you are giving out this content for free. Thanks so much. Stay abundantly blessed. Grace grace and more grace to you

[@AnalyticswithNags]

Thanks keep learning share this information with friends and colleagues

[@d.g0101]

This is the best video i have seen on DAX functions. Thank you sir for posting these.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@d.g0101]

@@AnalyticswithNags yes definitely. I am aiming for data analyst basically want to switch my career from a lecturer. Could you please help me how can I know how to make my power bi dashboards more insightful.

[@shivyogi806]

I'm blown in just 20 minutes into the video 👌👌..God Bless you and your family 🙏🏻
Thanks very much

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@user-ho5pk7fq6s]

Great Job Boss !!! The scenario-based explanations are awesome. Thanks a lot!!!

[@AnalyticswithNags]

Most welcome!

[@joesnicknacks]

I love this! Such amazing work! Thank you for taking the time to put this together and explain it in an easy to understand manner. I'm taking a lot of notes. Do you by chance have a PDF of this content so I can study further?

[@AnalyticswithNags]

You're very welcome!, unfortunately no, i don't have such material

[@user-qx1rx9tj5f]

Found this channel, accidentally!! And, it is absolutely excellent... Not just DAX, Power Query video is also good...

[@AnalyticswithNags]

Glad you enjoy it!

[@saurabhsoni6609]

Thank You So Much,,, Nag sir I really appreciate your efforts, thank you very very much for making this video, God bless You.

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@amithagnihotri]

Hi Nags, thanks for your videos n explaining Dax concepts clearly.
I have one doubt : what if our data have only month level information ( month and year in different columns) ? How to calculate MTD QTD & YTD ?

[@AnalyticswithNags]

If the data is in month level, no MTD is applicable. You can create QTD and YTD.
Also watch this video to understand how to convert month or year to date
czcams.com/video/84yEtx7MT04/video.html

[@imdeepu7855]

Very informative video...highly appreciated. Thank you Nags

[@AnalyticswithNags]

Glad it was helpful!

[@Mujmash]

Naga many thanks for the in detail video and great explanation..

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@vijayalakshmir4622]

Keep it up for all your efforts..You are great soul...

[@AnalyticswithNags]

Thank you, I will. Keep Learning

[@shuaibsaqib5085]

Very nice explanation in simple terms 👏

[@AnalyticswithNags]

Thanks keep learning

[@ramsureshj8985]

Great Video Nags, as Regular by you. Thanks so much.

[@AnalyticswithNags]

Thanks

[@didyouknowfacts9626]

I never seen such an easy and best way to explain DAX.
May god bless good health to Naga sir.

[@AnalyticswithNags]

Thanks and welcome

[@priyankakawade9681]

Thank u sir for this video 🙏🏻🙏🏻🙏🏻🙏🏻

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@mehranzafar8968]

Thanks a lot for the amazing content. Really appreciate your effort. I would like to make a request to you to make a video on Customer cohort analysis and customer churn analysis in power bi.

[@AnalyticswithNags]

Great suggestion!

[@saikrishnach777]

Good content. Thanks for sharing your knowledge.

[@AnalyticswithNags]

Glad it was helpful!

[@aziserak4743]

thank you so much your are one of the best power bi teachers 👌👌

[@AnalyticswithNags]

Thanks keep learning, share this channel with friends and colleagues

[@ashokteluguvlogs7248]

Thanks Nag for providing such videos
We are expecting SSIS packages migration to Azure ADF... Videos

[@AnalyticswithNags]

Sure I will make it soon

[@user-yi4sk1xu7e]

Its a grate channel for data analyst aspirants. i started follow this channel since i started my data analyst journey. could you please share the data set used for this video

[@ushasworld5223]

I would say this is the great video for me rather than paid classes thank you so much bro😊😊😊it helped me alot

[@AnalyticswithNags]

Thanks keep learning. If you are in LinkedIn talk about this channel in LinkedIn

[@balareddy9954]

Nice video it was very helpful to me
And I was hope upload PPT or Document in this (Power Bi , SSIS, SQL server) thankyou so much

[@AnalyticswithNags]

No we won’t share ppt

[@shagunagrawal2003]

Just completed the whole tutorial. I must say, IT WAS EXTRAORDINARILY AMAZING. THANKS THANKS THANKS.

[@AnalyticswithNags]

Share this channel with friends and colleagues. Talk about this channel if you are in LinkedIn

[@shagunagrawal2003]

@@AnalyticswithNags Sure, definitely gonna recommend it to whosoever may need it ❤️🔥

[@sireeshav936]

Thanks you so much Sir for sharing the knowledge

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@anushagorijavolu2341]

Thank you for great video. Very informative.🙏

[@AnalyticswithNags]

Glad it was helpful!

[@rekhak6690]

Hello Sir, I have been watching your videos ...thank you so much for your efforts.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@dikasa5346]

Very very informative. Thanks for fast course!
Good job!

[@AnalyticswithNags]

You are welcome!

[@mohan_nage]

Excellent Sir.
Thanks a lot 😊

[@AnalyticswithNags]

Most welcome

[@Kersssz]

Thanks a lot for such factual content. I wonder what is your source of motivation to devote so much time for preparation it. Anyway I really appreciate it.

[@AnalyticswithNags]

I love teaching people. That’s it.

[@Kersssz]

@@AnalyticswithNags All the more amazing. Once again thanks a lot.

[@EasyStreet88599]

Thank you very much for your hard work it's very well explained!

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@sureshmaxwel438]

Thanks for this great explanation on DAX. More to go :)

[@AnalyticswithNags]

Thank you Keep Learning

[@pallavidhatrak8984]

Thank you so much sir its really very helpful

[@AnalyticswithNags]

Thanks keep learning

[@user-if9is9vp7h]

very nicely explained DAX functions in an easy to understand manner.

[@AnalyticswithNags]

Glad you liked it

[@rohitkarnani0506]

Thank you so much sir, it is really helpful, kudos to you for sharing your content🙏

[@AnalyticswithNags]

Thanks and welcome

[@meeraajay8591]

Hi nags, its such a wonderful explanation. you have covered almost all the useful dax functions. It would be really great if you could share the datasets used in this video.

[@ajays8258]

Super thankyou much sir got good an idea & good info about dax sir:)

[@AnalyticswithNags]

Always welcome

[@irfanabbassi9202]

Thank you for the great lesson

[@AnalyticswithNags]

Thanks keep learning

[@prakashprajapati901]

Really nice video to understand dax function , thank you sir
😇😇

[@AnalyticswithNags]

You are most welcome

[@krkvibes1505]

Thank you thalaiva

[@AnalyticswithNags]

Cheers. Thanks keep learning

[@swethakandukuri6831]

thank you very much for very clear explanation so that even beginners with no idea can follow properly. Please make a video on imbedded skus

[@AnalyticswithNags]

Sure will make it soon

[@sowjanyakake5720]

Hello Sir, Thank you for the tutorial.. While practicing time intelligence functions, the dates values are showing up multiple records on same date in the pivot table soon after adding the salesAmount column to the table.. I dont understand the reason behind. So tried the formulas on different dataset, it worked.

[@AnalyticswithNags]

not sure

[@ROBROB301]

Found this super helpful - really comprehensive breakdown and explanations of the core concepts and functions👍

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@bhavesh3913]

Hi Nags, Thank you for making great video on DAX. I appreciate your efforts for this tutorial. If possible then could you please share DAX PPT which shown in video.

[@AnalyticswithNags]

No. We won’t share the ppt

[@harikrish7544]

Thank you So much Sir🤗

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@AmitKumar-ee7xj]

Super....Thanks for making this video👍👍

[@AnalyticswithNags]

Thanks keep learning

[@harshadachaudhari1607]

Thank you for the video. Would love to have advanced dax video as well

[@AnalyticswithNags]

Coming soon!

[@write2ruby]

26:12 --> 'Do not Summarize' feature from Column Tools:Summarization-Don't summarize
34:00 -> Calculated Table (Using DimDate)
34:15 -> Use of CALENDAR in DAX
49:51 -> SUMX
55:33 -> Use of All with DAX - Calculate
1:27:00 -> MAX, MAXA, MAXX

[@AnalyticswithNags]

What is your question or comment?

[@perfectionist6624]

Thank you sir❤❤❤✌🙏

[@AnalyticswithNags]

Thanks keep learning

[@NoorainRazaEC]

The way you explain every topic of DAX function with practical demo , I found ne where on youtube Sir. This course was very helpful. I learn a lot from this video.
Thank You so much for providing this amazing DAX function course.
Regards
Aspiring Data Scientist

[@AnalyticswithNags]

You are most welcome

[@mandarnandre7387]

Hi Nags, I am daily watching your videos for at least 2 hours. I am learning a lot. Please keep posting.
Question: How to change a running total sales column to a normal sales column?

[@AnalyticswithNags]

Have another measure next to running total

[@mandarnandre7387]

@@AnalyticswithNags I want to join your telegram channel please tell the name of channel. Link is not working

[@aniketwanjari2624]

​@@AnalyticswithNagsone question I have,I have an excel having open time in one column, so there are 1000 tickets, there open time mentioned in one column, there closed time mentioned in another column.
Open time : 10-02-2023 02:00:00 and closed time : 12-02-2023 02:00:00
So if calculate difference should be like 48:00:00 (48 hours, 00 minutes, 00 seconds)
I can get this format in excel but not in power bi. Please support

[@SaifKhan-rr3er]

Thanks. Very easy going learning.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@seema_shahabkhan]

Hi Nags thank you so much for another excellent video. Beautifully explained.
Have 2 doubts :
1)1:57;07 to avoid the hierarchy which is better to mark dimdate as the date table or to disable auto date time
2)2:03:36 which measure is better
US Sales = CALCULATE(SUM(FactInternetSales[SalesAmount]),DimSalesTerritory[SalesTerritoryCountry]="United States")
OR
US Sales = CALCULATE(SUM(FactInternetSales[SalesAmount]),filter(All(DimSalesTerritory),DimSalesTerritory[SalesTerritoryCountry]="United States"))

[@AnalyticswithNags]

1) to avoid hierarchy, disable auto datetime.
2) both are same. First query internally converts to second query

[@seema_shahabkhan]

@@AnalyticswithNags thank you so much. Appreciate your help fir clearing my doubts

[@winnieleung7139]

@@seema_shahabkhan Hi Nags! I would love to understand why we should avoid auto date time, is in your opinion using.[date] not a good enough solution, and do you see no benefits of using it?

[@arjunkare8150]

Its very helpful, i am waiting for such a video

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@pixel-frame]

this video helped me a lot. but only if i had the practice data with me side by side it would have been just perfect. but still if you understand the concept just by watching i believe you can apply the knowledge in nay dataset. thanx again for the amazing video.

[@AnalyticswithNags]

Glad it helped!

[@mahadheermohammed8944]

Thank you sir for this video. I am waiting for this type of blog for a very long time. Thanks ....!! Sir can you make a small video on embedded Analytics.!

[@pareshparab1695]

Can you provide the dataset
?

[@AnalyticswithNags]

Check the description I have update the link to the video

[@AnalyticswithNags]

Sure will make it soon

[@karangupta5401]

Great work was really confused before it.

[@AnalyticswithNags]

Glad it helped!

[@mohindaryadav8294]

Thank you so much sir ....

[@AnalyticswithNags]

Most welcome

[@sachingupta-ke3lc]

Big Thanks for this posting video.

[@AnalyticswithNags]

You're welcome

[@sundartamizh.m7383]

Excellent Explanation.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@itsall5180]

Amazing work superb

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@Kushdevfam]

Thank god...thank you sir for sharing dax..

[@AnalyticswithNags]

Thanks keep learning

[@vijayalakshmir4622]

Thanks Nags for all your videos...Will you Please do video on Python as well ...

[@AnalyticswithNags]

Soon will try to cover it

[@razzakahmad8731]

This video seems to be the Goldmine I have been searching for. Let's hope it actually has gold in it.

[@AnalyticswithNags]

Let me know what you found after learning the video😉

[@gopalakrishnan.p596]

Amazing!!!

[@AnalyticswithNags]

Thank you! Cheers!

[@badditulasirao5465]

This is really helpful, but the only thing is if you provide the Data in Excel format which is used in this course, it will be very greatful.

[@AnalyticswithNags]

Use adventure works database explained in the video

[@kumarmohit1231]

Very good content. Thanks

[@AnalyticswithNags]

Thanks. Keep learning

[@battenarajesh]

Great thanks Nag to post this video

[@AnalyticswithNags]

Always welcome

[@amritsinghania2722]

Thanks for all your efforts

[@AnalyticswithNags]

Thanks keep learning

[@amnril]

Very useful tutorial, thank you.

[@AnalyticswithNags]

Glad it was helpful!

[@emmanuelabiola7107]

Great job

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@priyajuneja178]

Hi Nags, I must say this video contains brilliant content, i love it, however i want to test on same data source. Can you please share the link.

[@AnalyticswithNags]

Check the description

[@thulasinagaraj6715]

I wish I could subscribe and like more than one
As much as possible
Ur class are really helpful
Thank u sir

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues. If you are in LinkedIn talk about this channel

[@ritudahiya6223]

Hi @analyticswithnags. Thank you for the knowledge you are giving. I come to know a new feature of power bi ie quick measure. As per this we dnt need to learn dax. Since you are master of this industry. Can you please guide is it still worth to learn this new skill.
We will get the job Or these new features like quick measure will take over it. Please reply

[@AnalyticswithNags]

No is the simple answer

[@ritudahiya6223]

@@AnalyticswithNags thank you

[@zaidnawali6543]

thanks bro for such a good video on dax thanks a lot

[@AnalyticswithNags]

Thanks keep learning

[@ananthakrishnan7060]

Thank you for the video.. Can you please share the datasets used for all of the examples you take

[@AnalyticswithNags]

thank you , keep learning

[@prakashdangi214]

Hello Analytics with Nags. Thank you for the amazing video. Can you upload excel sheet of adventure works that would be helpful for me.

[@AnalyticswithNags]

No. You need to use adventure works database.