No video
Advanced DAX [Full Course]
Рет қаралды 178,598
Күн бұрын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
✔️KZfaq: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
@MrPrakashsomani 4 жыл бұрын
Excellent explanation to the Advance DAX functions in easy way. I like the comparison of using %ge to grand total and using DAX.
@PragmaticWorks 4 жыл бұрын
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
@mwaltercpa 5 жыл бұрын
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.
@MitchellPearson 4 жыл бұрын
Thanks Mark!
@santiagowilches4276 3 жыл бұрын
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.
@wildecorrea6477 4 жыл бұрын
******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]
@officesuperhero9611 5 жыл бұрын
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.
@MitchellPearson 4 жыл бұрын
I did this as a webinar, didn't realize it had been posted on KZfaq, a better title may be appropriate! Thanks for the feedback Richard.
@khuramwani6832 Жыл бұрын
Mitchell I feel like I must pay for all your stuff. Your videos are are just Awesome! Thanks for this cool stuff
@PragmaticWorks Жыл бұрын
Thank you for watching! If you are interested in more Pragmatic Works training, please feel free to email training@pragmaticworks.com :)
@Sylphs47 3 жыл бұрын
Just want to let you know that this video help me a lot ! Great work !
@qingqingbales9722 2 жыл бұрын
I love all your videos. It's easy to understand for beginners like me. Thank you so much for posting!
@PragmaticWorks 2 жыл бұрын
Thank you for watching!
@danieldelgado-lw9br 2 жыл бұрын
This channel is amazing, It really adds some difficulty on power BI. I was tired of beginners tutorials
@PragmaticWorks 2 жыл бұрын
Glad you enjoyed!
@sameerqadri3884 Жыл бұрын
Hats off! Crisp and with clarity
@PragmaticWorks Жыл бұрын
Glad you enjoyed!
@christianbejani1298 Жыл бұрын
very clear explanation, thanks a lot for sharing.
@abhijitvetal576 2 жыл бұрын
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
@PragmaticWorks 2 жыл бұрын
We are glad to help!
@lma3996 4 жыл бұрын
Great tutorial video! Thank your for tips and tricks. Your video helped me to solve a puzzle in my learning process. Thank you again.
@MitchellPearson 4 жыл бұрын
Thanks for your comment and I'm glad the video helped!
@eerosiljander4622 10 ай бұрын
Great work! Thanks from Finland ! 😊
@rammasilang6776 4 жыл бұрын
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.
@PragmaticWorks 4 жыл бұрын
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.
@ajaypatil6862 Жыл бұрын
@@PragmaticWorks where is student file for this video? please help me out
@nguyenhoangtam4838 Жыл бұрын
Great video with detail explanation and guidance. Thank you very much
@jogdeepak 2 жыл бұрын
Excellent way of explaining, thanks for the video.
@gbthakkar 7 ай бұрын
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.
@SM-cs3nt Жыл бұрын
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.
@this.is.lapc506 4 жыл бұрын
The USERELATIONSHIP function would be really helpful a long time ago for me. Thanks a lot.
@PragmaticWorks 4 жыл бұрын
We are glad to hear that!
@dipteshbhattacharjee7010 3 жыл бұрын
Good one.. Really helps....
@pmsocho 3 жыл бұрын
Awesome explanation! Great skills!
@adamloewen456 3 жыл бұрын
Fantastically helpful video!
@tarcisioalthoff8738 4 жыл бұрын
Nice webinar. Thanks for sharing.
@PragmaticWorks 4 жыл бұрын
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
@matuwuhou 3 жыл бұрын
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?
@Kmsbi 4 жыл бұрын
Great tutorial
@PragmaticWorks 4 жыл бұрын
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
@decentmendreams 3 жыл бұрын
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.
@felipesouza9962 2 жыл бұрын
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?
@toulasantha 4 жыл бұрын
Thanks bro
@MitchellPearson 4 жыл бұрын
You're, welcome.
@syedzeeshan6697 2 жыл бұрын
Can you please send the link to download this excel sheet for practice?
@helenw1469 4 жыл бұрын
very helpful
@MitchellPearson 4 жыл бұрын
Thanks Helen.
@ducloc632 Жыл бұрын
Thanks for the video!
@sidmanthani3319 3 жыл бұрын
Is it just me, or is the audio quality not so great on this video?
@zishanafzal6671 3 жыл бұрын
where to get the excel file that you are using?
@chahineatallah2636 2 жыл бұрын
Great videos !
@PragmaticWorks 2 жыл бұрын
Glad you like them!
@peternguynguyen5208 4 жыл бұрын
Great tutor
@MitchellPearson 4 жыл бұрын
Thank you.
@cheoles4190 Жыл бұрын
Great content, even 4 year later :)
@Reduce_Scan 2 жыл бұрын
Thank You , please language MDX That used in PivotTable Is it related to DAX and Are there any educational materials for this language?
@fadwa2413 2 жыл бұрын
لا يا محمد ملهاش علاقة Dax حاجة MDX حاجة عموما ال MDX مش هتحتاج تتعلمها في الاول ..عادي يعني
@Reduce_Scan 2 жыл бұрын
@@fadwa2413 محتاج مقاطع تعليمية لل mdx
@fadwa2413 2 жыл бұрын
@@Reduce_Scan تابع documentation
@smcs 11 ай бұрын
is there a certification of completion?
@manoulomanoulo7 2 жыл бұрын
Hey nice video! Where can we find the data set of the example?
@jw8s 7 ай бұрын
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?
@nilavnayan4521 2 жыл бұрын
Hello, please give us the dataset link so that we can practice as well. Thanks.
@sathyak6254 3 жыл бұрын
Hi..can anyone say the diff between quantity listed vs total homes on market.and why we are using all(mlsdata) in last dax
@duvanm2483 2 жыл бұрын
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
@fernandocamargo2637 5 жыл бұрын
Great Video, tks for the content!
@MitchellPearson 4 жыл бұрын
Thanks Fernando, I'm glad it helped.
@Siberian_valenok 4 жыл бұрын
40:05 Oops :) great presentation, thx!
@toulasantha 4 жыл бұрын
“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
@MitchellPearson 4 жыл бұрын
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.
@snackymcgoo1539 Жыл бұрын
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?
@Phoenixspin 2 жыл бұрын
I started out in and am stuck in the Anger Phase.
@PowerBIMATRIX 8 ай бұрын
Does anyone have a pbix sample that Mitch used in this video?
@maryam4071 4 жыл бұрын
thanks for the video. Would you please to share data model file?
@raphaleju5136 4 жыл бұрын
Can anyone explain why there are 111 homes on the market when there are only 103 homes starting listed in 2011?
@MitchellPearson 4 жыл бұрын
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.
@raphaleju5136 4 жыл бұрын
@@MitchellPearson That's very helpful! Thank you so much!
@jjhmr 2 жыл бұрын
@@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?
@hastinowzari9077 Жыл бұрын
i waiting for the nexts
@HarishKumar-cg7en 4 жыл бұрын
Data Set is missing in the video ... Can you please update a link where we could download the dataset/files .
@PragmaticWorks 4 жыл бұрын
Good Morning Harish, there is no dataset for this video.
@HarishKumar-cg7en 4 жыл бұрын
@@PragmaticWorks Then how could we practice ? Practising is important when we watch videos....
@PragmaticWorks 4 жыл бұрын
@@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!
@Turbo_PilotSky 2 жыл бұрын
@@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
@In_a_state 3 жыл бұрын
Sorry, how is this advanced DAX?
@mathijs9365 4 жыл бұрын
SQLBI explains things very difficult. Too much in detail or technical.
@santiagowilches4276 3 жыл бұрын
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
@mathijs9365 3 жыл бұрын
@@santiagowilches4276 just watch YT from other experts.
@mhmodsalla587 2 жыл бұрын
51:22 😂😂😂😂
@PragmaticWorks 2 жыл бұрын
LOL, I had forgotten about that one 😀 -Mitchell Pearson
@hk_200k 8 ай бұрын
I'm in angry phase
@Kingcolumbian 4 жыл бұрын
Nah i dont see thismadvance
@techierahul281 5 жыл бұрын
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...
@alyismael91 5 жыл бұрын
Says someone who cannot spell ridiculous. This is a good video, if you didnt like it, just skip forward.
@decentmendreams 4 жыл бұрын
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.
@MitchellPearson 4 жыл бұрын
Sorry you were disappointed. I try to avoid slides when and where I can, I appreciate the critical feedback and will learn from it!
@datadragyn 2 жыл бұрын
@@MitchellPearson amazing video
@kifle16ify 2 жыл бұрын
Great Tutor Thank you
Fabiosa Best Lifehacks
Рет қаралды 29 МЛН