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.
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.
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.
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.
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
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.
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?
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.
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
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
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?
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.
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 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?
“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.
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?
@@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
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...
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.
![Beginner Power BI DAX Functions Tutorial [Full Course]](http://i.ytimg.com/vi/QJw4HkagVWc/mqdefault.jpg)
![Beginner Power BI DAX Functions Tutorial [Full Course]](/img/tr.png)
![Power BI DAX Tutorial - Beginner to Advanced [Full Course]](http://i.ytimg.com/vi/4rC9Ow76n0U/mqdefault.jpg)
![Advanced DAX: Problem, Design, Solution [Heavy Demo]](/img/1.gif)
******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]
very clear explanation, thanks a lot for sharing.
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
Hats off! Crisp and with clarity
Glad you enjoyed!
Great work! Thanks from Finland ! 😊
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.
Just want to let you know that this video help me a lot ! Great work !
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 :)
Great video with detail explanation and guidance. Thank you very much
Good one.. Really helps....
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.
Fantastically helpful video!
Excellent way of explaining, thanks for the video.
Can you please send the link to download this excel sheet for practice?
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.
This channel is amazing, It really adds some difficulty on power BI. I was tired of beginners tutorials
Glad you enjoyed!
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
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
where to get the excel file that you are using?
I love all your videos. It's easy to understand for beginners like me. Thank you so much for posting!
Thank you for watching!
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.
Thanks for the video!
Hey nice video! Where can we find the data set of the example?
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?
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.
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!
Hello, please give us the dataset link so that we can practice as well. Thanks.
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?
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!
is there a certification of completion?
Great videos !
Glad you like them!
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 bro
You're, welcome.
Awesome explanation! Great skills!
thks bro. but without files attached. it has limited usage....
Hi..can anyone say the diff between quantity listed vs total homes on market.and why we are using all(mlsdata) in last dax
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?
very helpful
Thanks Helen.
The USERELATIONSHIP function would be really helpful a long time ago for me. Thanks a lot.
We are glad to hear that!
Great content, even 4 year later :)
Does anyone have a pbix sample that Mitch used in this video?
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
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
Great tutor
Thank you.
thanks for the video. Would you please to share data model file?
I started out in and am stuck in the Anger Phase.
Great Video, tks for the content!
Thanks Fernando, I'm glad it helped.
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?
“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.
i waiting for the nexts
40:05 Oops :) great presentation, thx!
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?
Is it just me, or is the audio quality not so great on this video?
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.
Sorry, how is this advanced DAX?
I'm in angry phase
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