Power BI DAX Tutorial - Beginner to Advanced [Full Course]

Learn DAX from scratch in this comprehensive tutorial!
DAX is a powerful language that allows you to create custom calculations and measures in Power BI. It's essential for any data analyst or Power BI developer to know how to use DAX effectively.
This video will teach you everything you need to know about DAX, from the basics to more advanced topics. We'll cover the following:
Data Used :
www.pivotalstats.com/post/com...
Timecodes
0:00 - Overview
1:02 - Introduction to DAX
8:36 - Date & Time DAX 1 - Calendar & CalendarAuto
13:44 - Date & Time DAX 2 - Date, DateDiff, DateValue
21:05 - Date & Time DAX 2 - Now, Today, Day, Edate, EOMonth, Networkdays, Weekday
29:53 - Aggregate DAX - Sum, Count, Average, X Functions, Distinct
39:23 - Logical DAX - If, IfError, And, Or
47:12 - Text DAX - Upper, Lower, Concatenate, Len, Left, Right, Mid, Replace, Substitute, Search
57:36 - Filter DAX - Calculate, All
1:05:18 - Relationship DAX 1 - Related
1:10:50 - Relationship DAX 2 - Related vs. RelatedTable
1:18:27 - Relationship DAX 3 - Crossfilter
Microsoft DAX Learning - learn.microsoft.com/en-us/dax/
Excel Switch Function : • Why do we need SWITCH ...
Affiliate Links --
Best Web Hosting Service :
bluehost.sjv.io/k0OkNv
Cool tech that I use for these videos :
1. Blue Yeti Microphone - amzn.to/43FEYdT
2. LG Ultrawide Curved Monitor - amzn.to/3rEMsR7
power bi dashboard,power bi,power bi dashboard tutorial,power bi tutorial,power bi dashboard design,power bi tutorial for beginners,power bi for beginners,microsoft power bi,learn power bi,sales dashboard in power bi,power bi training,power bi desktop,how to create dashboard in power bi,power bi reports,power bi project,power bi dashboards,power bi report,power bi kpi dashboard,dashboard in power bi,how to power bi,power bi dashboard examples

[@hemantkumarchaurasia722]

This is the best dax tutorial ever seen on youtube. Hope that more useful content will be shared by the Pivotalstats🙏

[@pivotalstats]

Much appreciated! Will definitely try my best :)

[@parthtandel5848]

Loved the way you explain and presented !!! Keep bringing such valuable content.

[@pivotalstats]

Thank you, I will

[@OluwaseunK]

This is such an explicit coaching, thank you for every bit of explanation. It has helped a great deal

[@pivotalstats]

Glad it was helpful!

[@gustavopineda7933]

I really liked the presentation and effects of the video, very good work and also the very interactive teaching.

[@pivotalstats]

Thank you very much!

[@infusionchurchmd]

Absolutely loved this masterclass!

[@pivotalstats]

Glad you enjoyed it!

[@tyronefrielinghaus3467]

Fantastic...best DAX explanation ever. Step by step. No waffle. No confusion. Screenshotted the fax categories very early on in the video. Thanks so much.

[@pivotalstats]

Awesome, thanks for watching!

[@sunnyboy6433]

I have found your explanation easy to follow, using straightforward examples and your approach method to break down complex DAX is much appreciated.

[@jayxpea]

This was a VERY good introduction video. Really appreciate the content

[@pivotalstats]

Thanks!

[@azzurikayvo]

clear and straight to the point.A well done tutorial.

[@pivotalstats]

Thank you so much!

[@chinmayrane60]

Very well explained. Thank You..

[@pivotalstats]

Welcome! 🙂

[@sakshikothari7689]

Amazing content and delivering. You have made every concept simple to understand. Thank you for such great explanations. Keep posting insightful videos like this, they are really helpful.

[@pivotalstats]

Thank you so much, will do!

[@monubhaiya9022]

Thanks for helping us with this project ❤❤❤Please keep teaching ❤❤

[@pivotalstats]

Really glad it was helpful. Sure I will try to come up with more useful content 👍

[@gospelmoto2833]

Wow! useful. Thanks for sharing.

[@pivotalstats]

Glad it was helpful!

[@akupatichiranjeevi6159]

Kudos to your effort🎉🎉even one second also i don't missed it.. For me it is helpful alot... Thanks for awesome content

[@pivotalstats]

Really glad that it helped. Thanks for watching!

[@karanladla4911]

One of those videos which is going to be helpful almost everytime we'll work on P-BI. Thanks Sajit.

[@pivotalstats]

Glad to hear that. Thanks for watching!

[@deepdiveintolife]

Great explanation

[@pivotalstats]

Thanks!

[@mahithamylo66]

Great content do more videos to help in PBI Mock Interviews, Thanks and God Bless you! 😇

[@pivotalstats]

Thank you! Will do!

[@chaitu361]

fan of your work....boss...

[@pivotalstats]

Thank you so much 😀

[@oukiebotha2227]

The best DAX tutorial. Many thanks. Much appreciated....Thank you..Thank you..🙏🙏🏆🏆👌👌

[@pivotalstats]

You're very welcome! Thanks for watching!!

[@akshaykhobragade8494]

i looked many videos but found this is the best. what an explaination, clear concept, no confusion, short notes are very valuable, and i also appreciate your preffered techniques. thankyou for such amazing and valuable content video

[@pivotalstats]

Thank you for the appreciation. Really glad that it helped! 🙂

[@osoriomatucurane9511]

This is absolutely awesome, concise and crystal clear! Well done Sir. Do u have a tutorial convering row and filter contexts?

[@pivotalstats]

Thanks! I did cover filter context on an high level in my previous data model videos but I will create a dedicated video soon. Thanks for watching!

[@osoriomatucurane9511]

@@pivotalstats fantastic! Looking forward to see it.

[@perfectionist6624]

Thanks ❤❤❤

[@pivotalstats]

You're welcome 😊

[@user-qc1ct8jb7u]

Really good ...

[@pivotalstats]

Thanks a lot 😊

[@2076mayank]

Amazing Looking for a video on data flow And Ms Fabric

[@pivotalstats]

Thanks! Sure I'll plan for something in future, since dataflow requires a premium license.

[@user-ve5gj5vo8e]

Thank You

[@pivotalstats]

You're welcome

[@nariroeplal1553]

Best and easiest explained. Please do upload more😅

[@pivotalstats]

Thank you, I will !

[@poeziya5236]

thank you

[@pivotalstats]

Welcome!

[@jani1914]

Not fully watched but best impression 🎉

[@pivotalstats]

Thanks 🙂

[@lalitkaushik1812]

Great job. how to get the second largest value from a column?

[@pivotalstats]

Thanks! To get the 2nd largest, you can use a combination of Var, Max & Calculate function. Something like below: SecLarg = var larg = MAX(PizzaSales[Sales]) RETURN CALCULATE(MAX(PizzaSales[Sales]),PizzaSales[Sales] < larg)

[@lalitkaushik1812]

@@pivotalstats Thank you so much dear. This is a great help. Please start making videos in hindi as well for wider audience.

[@user-go5ri7zo9p]

Hi! How did you merge the two tables of sem1 score and sem 2 score, when im trying, there are 48 rows instead of 12, im guessing the similar subjects rows are getting repeated in the merged table

[@pivotalstats]

Hi, I think you must have skipped a step. In the video we are merging 2 columns within the same table and then finally using that merged column to utilize RELATEDTABLE to get required information from 2nd table.

[@sunlight00000]

Hi! a newbie here in PowerBI.Is this much DAX is enough to get into industry?

[@pivotalstats]

Hi, yes this is a good starting point for you. Once you understand how to structure the dax using this video, you can then move on to creating more complex logics by combining what you learned.

[@Mohamed-yb2xy]

hi tank you for your video pleas i need your help in a project i have two fact tables and i want calculate a KPI using DAX this KPI is the result of the devision of two columns one from the first fact table and the other from the other fact table but the probleme is that those fact tables are not related and i cant related them, but they have some sheard dimension tables, pleas tell me how can i calculate this KPI ,i have done manu search in the internet but i did not find the answeer ?

[@pivotalstats]

I doubt if that's possible but I will keep looking and let you know if I find a solution.

[@Mohamed-yb2xy]

@@pivotalstats thank you, some people use treatas function to create a vitual relationship between two tables but i am still reading about that, yes pleas don't esitate if you found a solution.

[@jawa5692]

Sir, will powerbi certification helpful?how to prepare for PL 300 certification?

[@pivotalstats]

Yes, definitely! Check out below link for understanding the broad outline suggested by Microsoft. Then you can use free resources on KZbin or go for any paid course on Udemy etc.. for your preparation. learn.microsoft.com/en-us/shows/exam-readiness-zone/preparing-for-pl-300-prepare-the-data

[@kavyamohan9725]

Sir please post complete powerbi course to became a powerbi developer sir

[@pivotalstats]

Hi, you can check out the power bi playlist. It covers all concept which you need to become a pbi developer : kzbin.info/aero/PLvkYWwzsiISGhkvknBg9eWneAizEumD0D&si=rVPTKZ0_7zS0TCfh

[@asp4628]

Sir,please Do more real world project advance level

[@pivotalstats]

Sure 👍

[@Lepu-bz1kd]

Content is very good, but your articulation of words are just wow. Make a course for articulation as well JK 😂

[@pivotalstats]

😁👍

[@SunriseBusinessClub]

absolutely useless

[@pivotalstats]

If you can elaborate then that would be really helpful. I will use that feedback to generate even better content in future. Thanks!

[@osoriomatucurane9511]

I guess he meant absolutely useful