Advanced DAX [Full Course]

Подписаться 226 тыс.

Просмотров 177 тыс.

50% 1

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.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan:prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com

Опубликовано:

10 сен 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 99

@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.

@Sylphs47 3 года назад

Just want to let you know that this video help me a lot ! Great work !

@pmsocho 3 года назад

Awesome explanation! Great skills!

@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!

@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!

@jogdeepak 2 года назад

Excellent way of explaining, thanks for the video.

@adamloewen456 3 года назад

Fantastically helpful video!

@nguyenhoangtam4838 11 месяцев назад

Great video with detail explanation and guidance. Thank you very much

@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.

@christianbejani1298 Год назад

very clear explanation, thanks a lot for sharing.

@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?

@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

@eerosiljander4622 9 месяцев назад

Great work! Thanks from Finland ! 😊

@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?

@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!

@Siberian_valenok 4 года назад

40:05 Oops :) great presentation, thx!

@fernandocamargo2637 4 года назад

Great Video, tks for the content!

@MitchellPearson 4 года назад

Thanks Fernando, I'm glad it helped.

@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

@sameerqadri3884 Год назад

Hats off! Crisp and with clarity

@PragmaticWorks Год назад

Glad you enjoyed!

@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 :)

@dipteshbhattacharjee7010 3 года назад

Good one.. Really helps....

@syedzeeshan6697 2 года назад

Can you please send the link to download this excel sheet for practice?

@nilavnayan4521 2 года назад

Hello, please give us the dataset link so that we can practice as well. Thanks.

@ducloc632 Год назад

Thanks for the video!

@zishanafzal6671 3 года назад

where to get the excel file that you are using?

@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

@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

@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 RU-vid, a better title may be appropriate! Thanks for the feedback Richard.

@maryam4071 4 года назад

thanks for the video. Would you please to share data model file?

@manoulomanoulo7 Год назад

Hey nice video! Where can we find the data set of the example?

@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

@peternguynguyen5208 4 года назад

Great tutor

@MitchellPearson 4 года назад

Thank you.

@helenw1469 4 года назад

very helpful

@MitchellPearson 4 года назад

Thanks Helen.

@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!

@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]

@toulasantha 4 года назад

Thanks bro

@MitchellPearson 4 года назад

You're, welcome.

@chahineatallah2636 2 года назад

Great videos !

@PragmaticWorks 2 года назад

Glad you like them!

@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.

@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!

@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

@PowerBIMATRIX 7 месяцев назад

Does anyone have a pbix sample that Mitch used in this video?

@smcs 10 месяцев назад

is there a certification of completion?

@jw8s 6 месяцев назад

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?

@gbthakkar 6 месяцев назад

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.

@cheoles4190 Год назад

Great content, even 4 year later :)

@sidmanthani3319 3 года назад

Is it just me, or is the audio quality not so great on this video?

@hastinowzari9077 Год назад

i waiting for the nexts

@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?

@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

@Phoenixspin 2 года назад

I started out in and am stuck in the Anger Phase.

@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.

@mhmodsalla587 2 года назад

51:22 😂😂😂😂

@PragmaticWorks 2 года назад

LOL, I had forgotten about that one 😀 -Mitchell Pearson

@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?

@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.

@In_a_state 3 года назад

Sorry, how is this advanced DAX?

@hk_200k 7 месяцев назад

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!