Advanced DAX [Full Course]
HTML-код
- Опубликовано: 8 сен 2024
- The DAX language was designed specifically so that users could quickly learn the basics and immediately improve the analytical capabilities of their data models. But then what? The DAX language can be difficult to understand once you master the basics and begin moving on to more complex calculations. In this demo-heavy webinar, we will focus on the building blocks necessary for building more complex calculations in DAX.
If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "youtube30" at check out when purchasing our On-Demand Learning classes to get extra 30% off - pragmaticworks...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan:prag.works/odl...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RUclips: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
******STEP BY STEP******
10:07 Variable: VAR + RETURN
13:30 Working with variables
******MEASURE*****
20:24
1 Dynamic Measure =
2 VAR LastSaleDate = LASTDATE('Internet Sales Filtered'[Order Date]);
3 VAR LastDayOfMonth = LASTDATE('Date'[Date]);
4 RETURN
5 IF(LastSaleDate LastDayOfMonth;
[Forecast YTD Sales]; [YTD Sales])
******FILTER CONTEXT******
23:24 CALCULATE
24:53 ALL
29:06
1 % of Total =
2 DIVIDE ([Total Sales];
3 CALCULATE([Total Sales];
4 ALL('Geography'[Country])))
34:53 FILTER
37:04
1 Quantity Sold =
2 COUNTROWS('MLS Data')
40:19
1 MLS Data 2016 =
2 FILTER('MLS Data';
3 YEAR('MLS Data'[Sold Date]) = 2016)
43:26
Quantity Listed =
2 CALCULATE([Quantity Sold];
3 USERELATIONSHIP('Date'[Date]; 'MLS Date'[Listing Date]))
52:05
1 Total Homes on Market =
2 CONTROWS(
3 FILTER(
4 ALL('MLS Data');
5 'MLS Data'[Sold Date] >= MIN('Date'[Date]) &&
6 'MLS Data'[Listing Date]
Excellent explanation to the Advance DAX functions in easy way. I like the comparison of using %ge to grand total and using DAX.
Prakso, we are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: success.pragmaticworks.com/ondemandlearning-free-trial
Great video, explaining the learning curve of DAX is very appropriate for business users. I remember feeling very confident, then feeling lost for a while.. to master DAX, you really do need to be willing to push through.
Thanks Mark!
Hi, Mark any advice for somebody just starting? I was learning the different functions DAX offers and felt pretty good about it, then I started to notice it was very hard to get my DAX measures to give me the results I was looking for. I'm currently reading the definitive guide to DAX by SQLBI, I'm on page 160 learning evaluation contexts. To be honest I feel so overwhelmed because I do understand the concepts but can't get my measures to do what I want.
Mitchell I feel like I must pay for all your stuff. Your videos are are just Awesome! Thanks for this cool stuff
Thank you for watching! If you are interested in more Pragmatic Works training, please feel free to email training@pragmaticworks.com :)
Hats off! Crisp and with clarity
Glad you enjoyed!
I think the topics you cover here are excellent but your title of this video and description do not lend itself to getting more views. I suggest that you include topics in title and description. You deserve more views. You are a very good teacher.
I did this as a webinar, didn't realize it had been posted on RUclips, a better title may be appropriate! Thanks for the feedback Richard.
very clear explanation, thanks a lot for sharing.
I love all your videos. It's easy to understand for beginners like me. Thank you so much for posting!
Thank you for watching!
Just want to let you know that this video help me a lot ! Great work !
Great work! Thanks from Finland ! 😊
Great tutorial video! Thank your for tips and tricks. Your video helped me to solve a puzzle in my learning process. Thank you again.
Thanks for your comment and I'm glad the video helped!
This channel is amazing, It really adds some difficulty on power BI. I was tired of beginners tutorials
Glad you enjoyed!
Kudos to you man You have done great job I was trying to find correct total throughout the Internet I didn’t get anything now I know. Thank you man really appreciated !!this was the video I needed indeed
We are glad to help!
Great video with detail explanation and guidance. Thank you very much
Thank you very much for this content. You've given exact answers to the questions that I cannot find anywhere else in the internet. I totally relate to the learning curve presented and hopefully I can make important progress to the report I am building.
Hi Ram... thanks for the feedback. We are glad to hear that this video was helpful to you. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
@@PragmaticWorks where is student file for this video? please help me out
Excellent way of explaining, thanks for the video.
Good video.
But I wouldn’t call this ‚advanced‘ DAX
These are fairly basic DAX calculations that you learn through the beginning.
Something I would really like to see more of is how to nest iterator functions to perform calculations on a groupBy level.
For example if I have a sales order table with sales id and customer number, how do I perform calculations by grouping by customer Nr and then having evaluations made by that grouping.
These start to get fairly complex from the beginning so I would love to have some structured introduction to those types of measures.
Good one.. Really helps....
Fantastically helpful video!
Hi, Great video. Thank you.
But wish to point out that the "Total Home on the Market" (53 min), is still incorrect.
The meaning of the formula is that, the home listed and sold in the same year.
So if we look at 2012- total listed is 260, so the value for "Total home on the market" can not be more than 260.
Please clarify.
Nice webinar. Thanks for sharing.
Glad you liked it. Tarcisio, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
Awesome explanation! Great skills!
The USERELATIONSHIP function would be really helpful a long time ago for me. Thanks a lot.
We are glad to hear that!
Great tutorial
Thanks for the feedback. I am not sure if you know, but we offer many On-Demand Learning courses in case you need more training. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
Thanks for a nice video! Can someone intuitively explain the first argument of ALL()? Why did he chose 'Geography'[Country] for calculating total sales? What if he chose 'Geography'[State] or anything else?
Thanks bro
You're, welcome.
Thanks for the video!
very helpful
Thanks Helen.
Hi Mitch, this is an awesome application for a person such as myself who works in the hospitality industry. How can I modify the LASTDATE to show as of yesterday? I am trying to dictate a measure that says if it is before today use ACTUAL otherwise use the FORECAST. Thank you so much!
Additional:
I was able to find a solution for it.
Thanks again.
Great videos !
Glad you like them!
Thank You ,
please
language MDX That used in PivotTable
Is it related to DAX
and Are there any educational materials for this language?
لا يا محمد ملهاش علاقة
Dax حاجة
MDX حاجة
عموما ال MDX
مش هتحتاج تتعلمها في الاول ..عادي يعني
@@fadwa2413 محتاج مقاطع تعليمية لل
mdx
@@Reduce_Scan تابع
documentation
Great tutor
Thank you.
Can you please send the link to download this excel sheet for practice?
Excellent explanation, thanks for sharing!!! Just one question about your Dynamic Measure.
Is it going to work in case you have a completed month without a sale order in its last day?
Like a last sale order date on July 30 instead of July 31st?
Great content, even 4 year later :)
where to get the excel file that you are using?
So I am a few years late but maybe still someone can explain how at 53:06 Total homes on market at 2011 can be more than listed homes?
40:05 Oops :) great presentation, thx!
Great Video, tks for the content!
Thanks Fernando, I'm glad it helped.
Hi..can anyone say the diff between quantity listed vs total homes on market.and why we are using all(mlsdata) in last dax
Does anyone have a pbix sample that Mitch used in this video?
Hey nice video! Where can we find the data set of the example?
Hello, please give us the dataset link so that we can practice as well. Thanks.
Thanks for sharing. is there a link to download the files used in this video? if so, could you please share it with us ? thanks in advance
is there a certification of completion?
i waiting for the nexts
thanks for the video. Would you please to share data model file?
I started out in and am stuck in the Anger Phase.
“Total homes on Market” calculation is wrong ?
It shows sold within the year that were listed before end of year.
It doesn’t show listed but unsold from this and previous years....
Help me pls..... thanks
Hello and thanks for your comment. In this example, the calculation is correct because the data set only contains homes that sold. However, if the data set also contained homes that had not sold or were still on the market, then an additional filter would need to be added! In this case the calculation is correct, thanks.
Is it just me, or is the audio quality not so great on this video?
The presenters for pragmatic works seem to love, and I mean LOVE deleting the first letters they type because the switching between upper and lower case. wHy Do tHEy mistypE eveRy singLE MeaSure tiTLE?
Can anyone explain why there are 111 homes on the market when there are only 103 homes starting listed in 2011?
Great question Raphale. There were 8 homes that were listed prior to 2011 that eventually sold in 2012 (7 in 2010 and 1 in 2009) but the date table included in the data model started at 1/1/2011 and therefore we don't see the quantity listed for prior years.
@@MitchellPearson That's very helpful! Thank you so much!
@@MitchellPearson
I was thinking this was the reason. But then why do those 8 homes listed prior to 2011 not appear in an "Unknown" bucket in the "Quantity Listed" measure?
51:22 😂😂😂😂
LOL, I had forgotten about that one 😀 -Mitchell Pearson
Data Set is missing in the video ... Can you please update a link where we could download the dataset/files .
Good Morning Harish, there is no dataset for this video.
@@PragmaticWorks Then how could we practice ? Practising is important when we watch videos....
@@HarishKumar-cg7en... we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg There... you will find very structured courses designed for this purpose. Hope this helps. Thanks!
@@HarishKumar-cg7en Gosh , it is not India, leave your cast system mentality at the door. Why is it always someone else fault or responsibility to get everything served and arranged to you people. Where is dataset ? Where are your manners ? If you can’t think of getting any dataset from web , then go back to school and learn how to think for yourself. No one is your server here in western society. If you want to order people around stay within your territory , kopish
SQLBI explains things very difficult. Too much in detail or technical.
Do you have any other sources? I'm reading their book the definitive guide to DAX but I'm kind of overwhelmed, too much information
@@santiagowilches4276 just watch YT from other experts.
I'm in angry phase
Sorry, how is this advanced DAX?
Nah i dont see thismadvance
i seriously want to give you the feedback...you ate up our valueable first 15 mints to actually start telling about DAX why you guys can not tell us in straight way...you talk a lot but no productivity ....ridiculus video...
Says someone who cannot spell ridiculous. This is a good video, if you didnt like it, just skip forward.
I am just awestruck by the clarity of his thoughts ..Doesn’t do it for you. It does miracles for me. Why the negativity? Just move on to the other videos that work for you. What a sad world we live in.
Sorry you were disappointed. I try to avoid slides when and where I can, I appreciate the critical feedback and will learn from it!
@@MitchellPearson amazing video
Great Tutor
Thank you