Power BI DAX Tutorial - Beginner to Advanced [Full Course]
Вставка
- Опубліковано 26 чер 2024
- 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
![Hands-On Power Automate Tutorial - Beginner To Pro 2024 Edition [Full Course]](http://i.ytimg.com/vi/KsgxDz-nY_I/mqdefault.jpg)
![Hands-On Power Automate Tutorial - Beginner To Pro 2024 Edition [Full Course]](/img/tr.png)
Hi, Just a quick note, I made a mistake at 7:05. When Pizza shop runs a discount for 15%, I should have multiplied the number by 0.85 and not 0.15. Sorry for this!
This is such an explicit coaching, thank you for every bit of explanation. It has helped a great deal
Glad it was helpful!
clear and straight to the point.A well done tutorial.
Thank you so much!
This is the best dax tutorial ever seen on youtube. Hope that more useful content will be shared by the Pivotalstats🙏
Much appreciated! Will definitely try my best :)
Absolutely loved this masterclass!
Glad you enjoyed it!
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.
Awesome, thanks for watching!
I have found your explanation easy to follow, using straightforward examples and your approach method to break down complex DAX is much appreciated.
This is absolutely the best DAX tutorial.
Thankyou so much, glad u liked it !
Loved the way you explain and presented !!! Keep bringing such valuable content.
Thank you, I will
One of the best videos on DAX on UA-cam.
Thanks 🙂
I really liked the presentation and effects of the video, very good work and also the very interactive teaching.
Thank you very much!
This was a VERY good introduction video. Really appreciate the content
Thanks!
Wonderful video I have been working with BI for over a year now and I learned alot from your videos.
Great to hear! Thanks for watching :)
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.
Thank you so much, will do!
Very well explained.
Thank You..
Welcome! 🙂
Wow! useful. Thanks for sharing.
Glad it was helpful!
One of those videos which is going to be helpful almost everytime we'll work on P-BI.
Thanks Sajit.
Glad to hear that. Thanks for watching!
Awesome video presentation.
Excellent working examples.
Thank you...,
You are Welcome, thanks for watching!
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
Thank you for the appreciation. Really glad that it helped! 🙂
The best DAX tutorial. Many thanks. Much appreciated....Thank you..Thank you..🙏🙏🏆🏆👌👌
You're very welcome! Thanks for watching!!
Thanks for helping us with this project ❤❤❤Please keep teaching ❤❤
Really glad it was helpful. Sure I will try to come up with more useful content 👍
Super se Upper Power Bi DAX . Thank You for Providing Dax !!!
My pleasure, really glad you liked it!
fan of your work....boss...
Thank you so much 😀
Really great video, it covered everything and was easy to understand.. Thanks for this😊
You're very welcome!
Great explanation
Thanks!
very helpful...thank you..
You're welcome!
the most straightforward dax tutorial ever
Glad you liked it. Thanks for watching!
Kudos to your effort🎉🎉even one second also i don't missed it.. For me it is helpful alot... Thanks for awesome content
Really glad that it helped. Thanks for watching!
Thank You
You're welcome
Great content do more videos to help in PBI Mock Interviews, Thanks and God Bless you!
😇
Thank you! Will do!
Thanks ❤❤❤
You're welcome 😊
Thank you.....helpfull
You're welcome!
thank you
Welcome!
Really good ...
Thanks a lot 😊
This is absolutely awesome, concise and crystal clear! Well done Sir.
Do u have a tutorial convering row and filter contexts?
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!
@@pivotalstats fantastic! Looking forward to see it.
Amazing
Looking for a video on data flow
And Ms Fabric
Thanks!
Sure I'll plan for something in future, since dataflow requires a premium license.
Best and easiest explained. Please do upload more😅
Thank you, I will !
Not fully watched but best impression 🎉
Thanks 🙂
man if 15percent discount given on each pizza then while calculating the revenue u need to multiply with 0.85 not 0.15. it gave me so much trouble. but overall great job with the tutorial. learnt a lot
Yeah sorry about that. I realized my mistake after I published the video. Anyways I will pin a comment, so that no one else gets confused. Thanks for watching!
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
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.
Great job. how to get the second largest value from a column?
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)
@@pivotalstats Thank you so much dear. This is a great help. Please start making videos in hindi as well for wider audience.
Hey Sajit Simon...thanks for this top tutorial on Power BI DaX. I am not sure if I am right but at 45:51 onwards you feed the argument for Column 4 that: IF(PizzaSales[Sales] >=10..... Shouldn't it be either "IF(PizzaSales[Price_USD]>=10" OR "IF(PizzaSales[Sales]>=100" ?
Hi, I don't know whether I understood your question or not, but the main intent of this was to just show how to use IF along with AND, &&, OR, ||. So consider this as a blueprint with which you can create your own personal logic.
Let me know if you meant to ask something else!
@@pivotalstats So at 45:46 you start explaining to us about the mashup with IF with AND, OR, && logics. Here for the example you use IF(PizzaSales[Sales] >=10... so 10 is too low a number for [Sales] so I was wondering.... were you actually referring to the [Price_USD]? Shouldn't it be "IF(PizzaSales[Price_USD]>=10. Or if it was [Sales] that you were actually referring to then shouldn't it be "IF(PizzaSales[Sales]>=100"? Hope you got my question? 🙂
Hi! a newbie here in PowerBI.Is this much DAX is enough to get into industry?
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.
Sir, will powerbi certification helpful?how to prepare for PL 300 certification?
Yes, definitely!
Check out below link for understanding the broad outline suggested by Microsoft. Then you can use free resources on UA-cam 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
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 ?
I doubt if that's possible but I will keep looking and let you know if I find a solution.
@@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.
Sir please post complete powerbi course to became a powerbi developer sir
Hi, you can check out the power bi playlist. It covers all concept which you need to become a pbi developer :
ua-cam.com/play/PLvkYWwzsiISGhkvknBg9eWneAizEumD0D.html&si=rVPTKZ0_7zS0TCfh
Sir,please Do more real world project advance level
Sure 👍
Content is very good, but your articulation of words are just wow. Make a course for articulation as well JK 😂
😁👍
absolutely useless
If you can elaborate then that would be really helpful. I will use that feedback to generate even better content in future. Thanks!
I guess he meant absolutely useful
Please Correct me if I am wrong, but shouldn't the Function at 7:05 be RevDiscounted = SUMX(PizzaSales, ((PizzaSales[Sales] * PizzaSales[Price_USD])*.85)). Since the store ran a 15% discount so the pirce should be 85% of its initial price. Sorry I have not gone through the entire video at this point, but this doubt came to mind as soon as I saw this.
Hi, You are absolutely correct. I made a mistake there, it should have been .85 instead of .15. Thanks for highlighting, cheers!