DAX by examples

Поділитися
Вставка
  • Опубліковано 15 чер 2024
  • Learning DAX by examples is never a good idea! Watch why and get motivated in learning some theory first! Download sample file: www.sqlbi.com/tv/dax-by-examp...
    How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
    The definitive guide to DAX: www.sqlbi.com/books/the-defin...
  • Наука та технологія

КОМЕНТАРІ • 220

  • @M_Dolega
    @M_Dolega Рік тому +8

    It's one thing to know Dax, the other to be able to explain it so your grandmother can understand it This guy is no doubt a GREAT TEACHER!

  • @JohnSullivan1
    @JohnSullivan1 2 роки тому +47

    I feel like I learn Dax just by watching Alberto's hand gestures. 😂

    • @weav8060
      @weav8060 Рік тому +3

      An eye-talian thing

    • @ismaelkourouma5558
      @ismaelkourouma5558 Рік тому +3

      Because you said that now the only thing I am seeing is his hands 😢

  • @caterinagentili1034
    @caterinagentili1034 Рік тому +2

    Love how Alberto teaches: Example > Problem > Theory explaining the problem > Solution > Theory explaining the solution. This way you'll remember why you are doing what you are doing and HOW to solve issues.

  • @joaorataoo
    @joaorataoo 2 роки тому +13

    I've watched Mastering DAX twice and I've always learned something new.
    I still have many doubts about DAX and I still struggling to learn it, but when someone comes to me and ask me for some advice how to learn DAX, I always tell to study the theory first.
    In my opinion there are no shortcuts on learning DAX.

  • @Mr_monsters937
    @Mr_monsters937 2 роки тому +3

    Yeah, I live in Italy for a while. Grate respect for telling "it is more important to simply think and find solution and do not try to choose solution between existing ones"
    Thanks for the video!!!

  • @UlyssesHaq
    @UlyssesHaq 2 роки тому +62

    Ive been studying and applying DAX for almost 2yrs, and this introduction is STiLL so inspirational. The learning continues, and its a joy. Thank you.

    • @lorin-gabriellauran2559
      @lorin-gabriellauran2559 Рік тому +2

      @SQLBI this needs to become a series, this is so helpful to see DAX in action!

  • @New2you09
    @New2you09 2 роки тому +52

    I find the format of this video to be incredibly useful: working through a scenario exploring different methods. Pls do more like this.

  • @omenaokoro4693
    @omenaokoro4693 Рік тому +3

    Marco is proof that the world needs more gifted teachers. His ability to explain the theory of DAX and then translate it to practice is so much appreciated. I get DAX every time I listen to him: breaking down the logic, building the model and validating the solutions... Love it.

  • @thierrythomas6640
    @thierrythomas6640 2 роки тому +3

    Even I read Dax guide and watched Mastering Dax, I still learn with your videos.
    Thanks a lot…

  • @Mrglasshalfempty
    @Mrglasshalfempty 2 роки тому +16

    This is a masterful video. I can't imagine how much work, time, and intentionality went into getting this exact scenario to showcase all the ins-and-outs of the solution. Absolutely excellent in every way, and I cannot thank you enough!

  • @danishkhatik3955
    @danishkhatik3955 Рік тому +3

    You're the excellent dax tutor on UA-cam
    Thanks for making this content

  • @irfandaud7380
    @irfandaud7380 2 роки тому +2

    The Quality of this video is outstanding, and explanation is at Oscar Level.
    Legend will always remember the great contribution of SQLBI

  • @brianmullins8444
    @brianmullins8444 2 роки тому +15

    I love these long-form videos! There's so much more to learn here than just the DAX functions and syntax, and even theory. I love watching the methodical stepping through from start to finish, seeing the solution evolve along the way. Using summarize to check mid-stream results is brilliant, and it is my big take-away from this one. Probably seen it done a million times, but today it struck home. Thanks!

  • @supersql8406
    @supersql8406 10 місяців тому +2

    That explanation of how to use the measure vs calculation between column aggregation vs row by row iteration was superb! I have a much better understanding why I had so many issues before because I didn't quite understand that concepts. Thank you!!

  • @bhakthasingh8198
    @bhakthasingh8198 2 роки тому +2

    Mr Ferrari, Every single video of yours is so helpful, eye-opening and inspirational.

  • @steponaszonys8385
    @steponaszonys8385 4 місяці тому +1

    Amazing! I'm not an English speaker, but I understood it better than most courses in my native language.

  • @laurayork6530
    @laurayork6530 Рік тому +7

    Amazing teacher. This is only my second video that I watched from him and I love the detail he provides on each segment! Outstanding job!

  • @omarelali
    @omarelali Рік тому +2

    Thank you for the extremely informative video . These are the type of videos that a DAX learner needs the most, since it illustrates practical methods of utilizing dax functions .

  • @beginho2454
    @beginho2454 2 роки тому +3

    Greatest DAX mentors, thanks Alberto and Marco 👏👏👏
    Now I use DAX and PBI everyday

  • @ramisijare6807
    @ramisijare6807 Рік тому +2

    No idea what to say Alberto. Im really happy to learn from you. One of the best videos. End to End and easy to understand. A pleasure as always! Mille grazieeeeee. Greetings from Germany!

  • @kostaskolotouros4345
    @kostaskolotouros4345 2 роки тому +2

    What can I say... The way you explain the concepts is just incredible! Thank you.

  • @vyronis
    @vyronis 2 роки тому +2

    Very good full example video! It's longer than normal, but I like the idea of having a solution you need to build for, how to do it, and issues that may arise. Love your content.

  • @Amr-Ibrahim-AI
    @Amr-Ibrahim-AI 2 роки тому +3

    Alberto!
    Thank you so much for this lovely video.
    I enjoyed every moment and I love the way you deliver information.
    The line of thought is well presented and takes the audience step by step into the world of DAX in the best way ever.
    Thank you so much!

  • @ManahilNH
    @ManahilNH Рік тому

    This video is an excellent introduction to the DAX language! The presenter does a fantastic job of breaking down the language into understandable concepts and walking through practical examples. I feel much more confident in using DAX after watching this.

  • @wmfexcel
    @wmfexcel 2 роки тому +5

    This is a great video! Really appreciate it.
    I come from Excel world. I think what you says here can be applied perfectly to Excel too. It's not about knowing how many functions, it's about how we can use the combination of functions to solve our problem. And of course, the solid foundation is required for going further.
    Thank you very much. So much to learn from your channel!

  • @bedadhalathirumaleswarared8134
    @bedadhalathirumaleswarared8134 2 роки тому +4

    I enjoyed a lot more DAX concepts and problem solving techniques and tools in one video.
    Can you please do these kind of video series regularly.
    Thank you so much Albero Ferrari.
    I am big fan of you.

  • @felipesignorellireis7839
    @felipesignorellireis7839 2 роки тому +5

    Loved this class. Do more like this Alberto. Very very good class. cheers from Brazil.

  • @zhengxijiang4087
    @zhengxijiang4087 8 місяців тому

    20:00 FILTER( table, filter expression). Filter() creat a row context, we need to use nevigation function related()
    22:30 filter context, measure caculation is always under a filter context.
    24:50 CACULATE() works with filter context, not row context, it does not need RELATED() kind of nevigation funcions.

  • @pepecantu9477
    @pepecantu9477 2 роки тому +1

    Excelente curso, hoy me inscribí y lo mejor es que los videos tienen traducción al español. 100% recomendable. felicidades por tan excelente trabajo.

  • @bradj229
    @bradj229 2 роки тому +2

    This was an awesome walk through that covered many things in a very clear delivery. Thank you!

  • @assignfield6256
    @assignfield6256 2 роки тому +2

    This video explains real codes behind the written codes. Love you guys at the SQLBI.

  • @MrTC-rv3jo
    @MrTC-rv3jo Рік тому +2

    This is an amazing video Alberto! one of the best in this field and especially for those who are in the learning phase of this amazing language. Please make more of this kind! Enjoy DAX indeed!

  • @denizgurbuz3590
    @denizgurbuz3590 2 роки тому +2

    I am so happy to find this channel. Not only teaching the DAX , but also teaching deep and flexible thinking. Mr. Ferrari , can you do me a favor? If you can make a set of videos about PowerBI Report Builder ,Paginated Reports, I would greatly appreciate it. Looking forward to seeing the set of videos as well.

    • @SQLBI
      @SQLBI  2 роки тому +1

      We focus on data modeling and DAX, we cannot cover everything! :)

  • @MrDI7ME
    @MrDI7ME 2 роки тому +1

    I sincerely want to thank you for your amazing explanation DAX.
    Friend from Saudi Arabia ❤️

  • @HansdeCocq
    @HansdeCocq 2 роки тому +2

    Thanks for this clearly explained approach ., and ..............." you proof your point!" (about learning theory first and NOT to go for "Trail on error" )

  • @viniciusfernandes3552
    @viniciusfernandes3552 2 роки тому +1

    Thank you Alberto. It is always relieving watching you guys cz I see a hope one day will
    Master Dax. Cheers.

  • @xiaojienan7891
    @xiaojienan7891 3 місяці тому +1

    i bought your book and i found it is the best in the market, and your video is also the best

  • @ayyappagorrala7350
    @ayyappagorrala7350 2 роки тому +3

    WOW. you guys are real gurus of DAX. I thought 1 hr is long video, but it just went by . so immersive content. understanding everything that is shown in the video and anticipating what comes next made me feel very confident that i am not a novice . Aiming towards GURU :)

  • @shivyogi806
    @shivyogi806 2 роки тому +4

    We need more of such videos for: Advance Topics(DAX), please 🙏

  • @lukaszk4388
    @lukaszk4388 Рік тому +2

    great video ! the way of explaining how complex results can be achieved with using simple chunks of dax is awesome! little by little and little became a lot

  • @user-zk3cp7nt2o
    @user-zk3cp7nt2o Рік тому +1

    Great master. Every time I see this video tutorial, I could get some new subtle point to understand. Enjoyable learning experience

  • @Low_Code_DIY
    @Low_Code_DIY Рік тому +1

    非常喜欢这位老师的视频,一直关注着,每期必看

  • @andretan4606
    @andretan4606 2 роки тому +2

    Your videos really teach alot of useful techniques and examples of how to apply DAX. Would love to see more of such videos where you teach how to combine different DAX functions to prepare dashboard. The concept explanation is also very important and useful..

  • @mikem2246
    @mikem2246 2 роки тому +2

    One of the best teachers I'd the honor to learn 💪💪

  • @fiaztv3206
    @fiaztv3206 Рік тому +2

    absolutely incredible way to explain things. Thank you so much for your great contribution.

  • @anilsharma-iv6vd
    @anilsharma-iv6vd Рік тому +1

    I loved the way the whole scenario is explained & presented.

  • @vmcostaferreira
    @vmcostaferreira 2 роки тому +1

    Halfway through.. what a masterclass

  • @remuslupinhp
    @remuslupinhp 19 днів тому +1

    Thanks a lot... this is what I needed... I know the functions, but I don't know their applications.

  • @bouseuxlatache4140
    @bouseuxlatache4140 Рік тому +1

    thanks for those videos. you made me understand why some of my formulas were not working and the logic behind at work.

  • @TheBoussadra
    @TheBoussadra 2 роки тому +1

    Thanks, this is the best DAX tutorial I’ve seen

  • @rajeevkumarsharma1960
    @rajeevkumarsharma1960 11 місяців тому +1

    Very valuable practical session. Worth sending every second on it.

  • @kleimandd
    @kleimandd 2 роки тому +1

    Great lesson Alberto! Thank you for sharing.

  • @florina-vq1db
    @florina-vq1db 4 місяці тому +1

    Awesome presentation and very good examples! Thank you so much!

  • @HappyLandTravel
    @HappyLandTravel 11 місяців тому +1

    I really like your videos, thanks for creating such wonderful lessons!

  • @3danim8r1
    @3danim8r1 Рік тому +1

    Difficult question Simple solution step by step... that is really nice...Thank you so much for sharing.

  • @robertomarra2431
    @robertomarra2431 Місяць тому +1

    I followed the free Introducing DAX training offered by SQLBI and I like it very much, but I've to be honest, is because of this video here that I'm very inclined to subscribe to the Mastering DAX training course. I like the approach, that there is not a function for everything but most of the time you've to create it your own one. If Alberto can pls confirm me that Mastering DAX is following the same philosophy, very likely you'll have a new subscriber. Grazie molte

    • @SQLBI
      @SQLBI  Місяць тому

      We suggest to use the free trial, so you can see how Mastering DAX is made!

  • @patrickbcox
    @patrickbcox 2 роки тому +1

    Another Excellent Video! Very instructive! Thanks!

  • @krzysztofc6697
    @krzysztofc6697 Рік тому +1

    Thank you for your commitment to explaining DAX :)

  • @rohan92ful
    @rohan92ful 2 роки тому +3

    Very very helpful, kindly come up with more such videos

  • @BaniMoniah
    @BaniMoniah 2 роки тому +2

    Very informative video, thanks a lot for the very smooth explanation 👍🏻

  • @MD-cu6wq
    @MD-cu6wq 2 роки тому +1

    Subscribed! Awesome delivery, thank you!

  • @sarajvo2010
    @sarajvo2010 2 роки тому +1

    Simple and great. Thank you for learning content.

  • @aatsw
    @aatsw 2 роки тому +2

    Very neat, and informative. Well done, and thank you.

  • @Sreelalitha1903
    @Sreelalitha1903 8 місяців тому +1

    Heartfull of thank you for providing such a deeper insights.very well explained.Really awesome 👏

  • @pilarbaldominos2505
    @pilarbaldominos2505 2 роки тому +1

    Fantastic video! I have learned a lot of tips! Thanks Alberto!

  • @saharlatifi3510
    @saharlatifi3510 2 роки тому +1

    Excellent! This is extremely helpful. Thank you very much.

  • @gregoryoliveira8358
    @gregoryoliveira8358 10 місяців тому +1

    Great video as usual! Thanks for all this great material! Enjoy DAX! 🙂

  • @zaheralashker194
    @zaheralashker194 Рік тому +1

    Great methodology to explain, thank you so much

  • @KK-kc1mf
    @KK-kc1mf 2 роки тому +1

    That is the greatest DAX guide i have ever seen! Thak you!

  • @mnowako
    @mnowako 2 роки тому +1

    What an excellent lesson! Bravo!

  • @TNCYKR
    @TNCYKR 11 місяців тому +1

    Thank You for your informations.. This video is very helpful. Good Day.👋

  • @phuocvuhoang3606
    @phuocvuhoang3606 Рік тому +1

    Thank you very much for sharing, I learned a lot

  • @julie_chen
    @julie_chen Рік тому +1

    Wow, learned a lot just from this video. 🙏🙏🙏🙏👏👏👏👏

  • @jaliali84
    @jaliali84 2 роки тому +1

    I learnt so much from this video. Great explanation thank you so much 😊.

  • @erickampel8154
    @erickampel8154 Рік тому +1

    best powerbi video I have seen so far !!!

  • @kalinduSekara
    @kalinduSekara 2 роки тому +2

    This is a very informative video. Please do more videos like this.

  • @rcasturi55
    @rcasturi55 8 місяців тому

    Love your teaching . Thanks

  • @padynz9869
    @padynz9869 Рік тому +1

    Thank you very much for an exhaustive and lucid video ♥

  • @miazhao582
    @miazhao582 2 роки тому +1

    So excellent! Love it! Thank you for the content

  • @eleazarmontano9715
    @eleazarmontano9715 Рік тому +1

    Great explanation and samples

  • @rachellim4147
    @rachellim4147 2 роки тому +1

    Thank you very much ! Love it , learnt a lot of knowledges ! Please do more video like this

  • @__HumanBeing
    @__HumanBeing 2 роки тому +1

    1:10:11 This is so true guys, listen to this advice, maybe it is the most important lesson of this video! Thank you so much for this Alberto!

  • @Alireza-ih5vu
    @Alireza-ih5vu 2 роки тому +1

    Perfect
    Thanks Alberto

  • @powerb_i
    @powerb_i Рік тому +1

    Thank you this was a great video and very useful. Look forward to watching more videos on this channel.

  • @ameersuhelkhan4398
    @ameersuhelkhan4398 2 роки тому +1

    Thanks for this excellent course..!

  • @michele37276
    @michele37276 Рік тому +2

    Amazing video ! i am new to Power BI but i really love it and this example (which i replicated by myself) explains very well how DAX works; it will be long bu i will go trough all of the video as i want Power BI to be my next main tool for my next job

  • @rokiczaaa
    @rokiczaaa 6 місяців тому +1

    Great film, big thanks! I needed it :)

  • @cchristoff
    @cchristoff 2 роки тому +1

    Stellar explanation. Thank you!

  • @milosmil
    @milosmil 11 місяців тому +1

    Beautifully explained. Thank you!

  • @larslindberg745
    @larslindberg745 Рік тому +1

    Really good video. Alberto is a master at explaining

  • @bbbradl
    @bbbradl 2 роки тому +2

    This kind of foundational concept walk-thru is incredibly helpful! THANK YOU for not glossing over it.
    Regarding your use-case at minutes 30 - 32 "Ship Date relying on unique Order #".
    1. When determining uniqueness of [Order Number], why not just highlight 'Test'[Order Number] and see that the Count = Distinct Values, rather than bouncing back-n-forth between the Sales counts and Test counts?
    2. Side note: I don't agree with your assumption that [Order Number] must be unique for your results to be valid. Partial Shipments are commonplace in nearly every sales shipping enterprise. I believe that if an order were split between 5 shipments, then you'd have to ask the user if that should be treated as 5 orders, or 1 order that aggregates [Date Shipped] as "MAX", "MIN", or "AVERAGE" for that order. After all, just because your small test-case sample doesn't contain duplicates, that assumption can fall apart when you step into Production where there are millions of orders.

  • @refinedfalola
    @refinedfalola Рік тому +1

    Thank you so much. This is very insightful.

  • @lc1988
    @lc1988 Рік тому +1

    you saved my day, mister.

  • @__HumanBeing
    @__HumanBeing 2 роки тому +1

    Wow Alberto, thank you very much!

  • @Anthony_Lecoq
    @Anthony_Lecoq 2 роки тому +1

    Thanks Alberto, Great video as usual :) I aggree practicing without the theory is like starting building an house by the roof ;)

  • @EasyStreet88599
    @EasyStreet88599 Рік тому +1

    Amazing work !

  • @kittyind
    @kittyind Рік тому

    Nice to see your long video presentation.
    Did use dataset from Contoso 10M from Github. There was subtle differences between the data.
    1. Sales order table was header table (i.e 1 order per row).
    2. When #Orders/#All orders the number of decimal places was not identical to your presentation. This resulted in 100% appearing multiple times. I will work on it.
    3. I liked your explanation of creating the table with curly braces and use it for calculation. I had come across similar exercise where shipment (processing time to be calculated was ranging from 15 min, 30 Min, 1 hour, 2 hour, 4 hour, 1 day, 2 day, > 3 days). I had built a customized table, rather than using curly braces table.
    Also in this exercise i added a new column with concatenating values with number of days as < = 1days,

    • @SQLBI
      @SQLBI  Рік тому +2

      The sample data released on GitHub might be different that the one used in the video.

  • @Jamie-gu7ib
    @Jamie-gu7ib Рік тому +1

    More videos like this please! Thank you.

  • @mohsenabdelbaset
    @mohsenabdelbaset Рік тому +1

    thank you so much Alberto for this Great video

  • @kebincui
    @kebincui 2 роки тому +1

    Thanks Alberto!👍