👉Beginner Power BI DAX Functions Tutorial [Full Course]

  Рет қаралды 1,556,255

Pragmatic Works

Pragmatic Works

Күн бұрын

The DAX language allows developers to easily extend the analytical capabilities of their data model. DAX is a very intuitive language and has less of a learning curve than traditional programming languages. However, there are a couple of concepts in DAX that can be challenging! This 3-hour DAX session covers DAX fundamentals as well as topics like row context, the CALCULATE function and context transition.
-------------------------------------------------
Free Power BI Course - tinyurl.com/2ujujsb5
What you’ll learn:
✔️ DAX Fundamentals
✔️ Row Context and navigation functions
✔️ CALCULATE Function
✔️ Time Series Analysis
✔️ Semi-additive measures
✔️ Context Transition
Prerequisites: (to follow along or review later)
✔️ Power BI Desktop installed
✔️ Download student files (share.hsforms.com/19tBqW4XxSh...)
After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - share.hsforms.com/18APYPLg_Q_...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
👉 As a thank you for watching our Learn with the Nerds: Beginning DAX Concepts with Power BI conference, we put together a guidebook with everything you need to know about DAX, from how it works to how it can benefit your business, and we would like to share it with you! We hope this book gives you a clear understanding of DAX, what it can do for your data and help you get the most out of your DAX experiences.
Please, click on the link below to Download The Nerd's Guide to DAX for FREE!
prag.works/lwtn-trial
If you enjoy this Learn With the Nerds and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use the code "Mitchell30" to get an extra 30% off at check out when purchasing our On-Demand Learning classes from pragmaticworks.com/pricing/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗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
✔️KZfaq: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#Pragmaticworks #Microsoft #Training #DAX, #PowerBI, #PowerPlatform #MitchellPearson
**Any sale mentioned in the video are no longer valid. Offers are subject to change with/without notice and are for a limited time only.
00:00 Intro to DAX
10:00 Navigation function
14:00 Row context
17:00 Conditional logic
20:00 First pass rule in conditional logic
24:00 Building relationship
26:26 Active filters doesn't work in row context even if there is active relationship
30:11 Many to many relationship, use bridge table
33:00 Related or related tables in row context scenario when relationship filter doesn't work
36:20 Use of switch function
39:35 X functions
46:15 Calculated measures
48:00 Filter Context
49:25 Override filter context
51:30 Semi additive measures.
53:14 Time intelligence and importance of time table
56:27 Calculated measures done in the report view to see the changes in the report.
1:33:40 Why calculated measures and why not calculated columns
1:40:56 Modify filter context: use CALCULATE.
1:45:37 Remove filters
1:58:14 Using OR
2:01:00 Using IN for OR
2:09:19 Total year to date sale
2:10:00 Comparing curr and prev year
2:26:00 Semi additive measures
2:38:00 Opening balance month
2:45:00 Context transition

Пікірлер: 662
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
👉 Important files: ◉ Download student files - share.hsforms.com/19tBqW4XxShuwhVU1cgnQ2Q8xue ◉ Certificate of Completion - share.hsforms.com/18APYPLg_Q_W8z0sHzB6OPg8xue ◉ Download DAX guidebook - share.hsforms.com/1khBLVNX1RnuyJJROpSAqaA8xue
@jiaxinyu5031
@jiaxinyu5031 Жыл бұрын
Hi! there is some problem with downloading student files. Can you check it?
@PragmaticWorks
@PragmaticWorks Жыл бұрын
@@jiaxinyu5031 Hi, everything appears to be working on our end. Please try a different browser and let us know if that works! Thank you!
@pinoydataanalyst1705
@pinoydataanalyst1705 Жыл бұрын
Hi, can you also post the blogs mentioned in 1:37 ? thanks
@kingsleyandy7846
@kingsleyandy7846 Жыл бұрын
Hi, I cannot download Student Files??
@desktopdatacrunching4032
@desktopdatacrunching4032 Жыл бұрын
@@kingsleyandy7846 Are you receiving a specific error message? I just tried them and they seem to be working fine. If you're connected to a VPN you may need to temporarily disconnect.
@rishabhvashistha5313
@rishabhvashistha5313 Жыл бұрын
DAX cant be explained better, Your DAX and Modelling video is the reason behind the appreciation I get in my office.
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Glad we could help! Thanks!
@huntershikhari2729
@huntershikhari2729 Жыл бұрын
Is that a mere compliment or the true words?
@hugodasilvadasilva
@hugodasilvadasilva Ай бұрын
After watching dozens of videos in english, portuguese, on youtube and paid classes, trying to understand how row context, filter context and CALCULATE function works, I finally could comprehend that concept by watching this video. It's so simple that I still don't believe it. Thanks @PragmaticWorks for this video.
@kimrainman
@kimrainman 2 жыл бұрын
0:56 Logistics/FAQ ✔ 2:15 Attendee Files ✔ 3:45 Agenda ✔ 4:50 introduction to DAX ✔ 6:05 What is DAX used for? ✔ 9:04 Navigation Functions ✔ 10:42 Let's Write DAX ✔ 11:25 New Column for Full Name [concatenating two columns] ✔ 16:30 New Column for Age Breakdown [conditional] ✔ 20:50 New Column for Month Year ✔ 24:20 Build Relationship between two different tables [primary key] using Related ✔ Related only draw values from the One-Side to the Many-side 30:40 Total transaction-helper column using RelatedTable ✔ For RELATEDTABLE it can look up values from the Many-Side and bringing it into the One-Side 36:00 Region Volume using Switch() better than IfElse statements ✔ 39:15 Using Maxx function ✔ 45:15 Calculated Measures Intro ✔ 55:55 Just talking ✔ 56:45 Creating Display Folder (so that measures can be seen separately) ✔ 58:01 Measure Creation, Slicers 1:15 :30 Break 1:30:40 Resume CALCULATE with filter conditions using ALL() and REMOVEFILTERS() ✔ 1:46:10 Getting Percent of Total 1:48:00 Difference between Calculated Measure % total and using Built-in Grand Total ✔ 1:51:38 Total Sales using Calculate Filter ✔ 1:5800 Using ||, OR() in CALCULATE Function 2:00:40 Using In-Clause ✔ 2:02:05 Adding more filter conditions to CALCULATE 2:06:10 Total Sales where Year = 2007 ✔ 2:07:45 Time Series Analysis for Dates TOTALYTD YTD sales ✔ 2:14:10 Fiscal YTD Sales ✔ 2:16:50 Total YTD with filter conditions ✔ 2:19:40 Prior Year Sales ✔ 2:26:30 Semi-additive measures ✔ 2:45:00 Context Transition (MAXX vs CALCULATE(MAX) vs MaxDate Measure ✔
@PLUX4
@PLUX4 2 жыл бұрын
You are the real MVP. Thank you for posting the timestamps.
@ibejoseph19
@ibejoseph19 Жыл бұрын
Very helpful. Thank you
@thamilanban
@thamilanban Жыл бұрын
Thank you
@MagniFino
@MagniFino Жыл бұрын
all the best to you and everyone you care about :)
@dpoort64
@dpoort64 2 жыл бұрын
I have been learning DAX by myself for the last few months, and this is the first video that really manages to explain these concepts in enough depth and in a way that is easily understandable. Thanks so much!
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Glad you enjoyed!
@lakeshed
@lakeshed Жыл бұрын
PW is currently the best learning platform as far as BI is concerned, they have assembled the best Nerds in the field. The most interesting part is the passion with which those guys have for the subject. I have spent a lot on their platform and I can tell you that it is worth every penny. You basically pick up the materials and apply them to your job and you are fine, it is that effective. Mitchel and Manuel are my favorites
@CSHarvey
@CSHarvey 2 жыл бұрын
Oh. It's a way to do sql queries inline in PowerBi without having to write SQL queries. Neat.
@ReddyReddy-gc8dt
@ReddyReddy-gc8dt 2 жыл бұрын
Yyyyýyyyyy4y6 Uk4
@ReddyReddy-gc8dt
@ReddyReddy-gc8dt 2 жыл бұрын
Mmm
@davidlydike5021
@davidlydike5021 3 жыл бұрын
Years of experience and passion for Business Intelligence compressed into 3 hours. Incredible speed throughout the entire session but not a single redundant sentence. Wow.
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
Thanks for this awesome feedback Dave! Glad you enjoyed the video.
@chisomnkoloagu9038
@chisomnkoloagu9038 Жыл бұрын
Richard I usually don't comment on videos but you are completely out of this world. Your experience in this is so amazing and looking at you do all this completely shows you have gone a long way with it. The way you teach, make references and use different formulars is just so great. Thank you so much.
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Thank you so much 😀
@Super123ok
@Super123ok Жыл бұрын
I find tutorial videos from Pragmatic Works are simply the best! As someone who recently started working with Power BI regularly, it was good to come back to the basics in order to understand why i made those DAX mistakes I made and how to correct those and prevent them from happening again. I also watched the series from Pragmatic Works on Data Modeling- highly recommend it!
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Thank you so much! Happy to help!
@mmorpe
@mmorpe Жыл бұрын
Mitchel, I am new to DAX, and yet I remained glued to your session for complete 3 hrs. You are simply awesome.
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Awesome, thank you!
@rajatbi1104
@rajatbi1104 3 жыл бұрын
I saw many Power BI Videos, but your training skills are really awesome.
@MitchellPearson
@MitchellPearson 3 жыл бұрын
This is great feedback Rajat, thank you so much. I had a lot of fun and I'm glad you enjoyed the training.
@karankatam6684
@karankatam6684 Жыл бұрын
The course has been taught at the right pace and the resources provided has given it a perfect hands-on training experience. Thank you so much Mitchell!!! Really appreciate the time you have taken for this. looking forward for your other courses and advanced DAX workshop.
@jesse7631
@jesse7631 7 ай бұрын
So, I have watched many Power BI / DAX tutorials, but yours is the tops! Sam McKay at Enterprise DNA is very good, but the way you describe how and why to do things and how measures works is just the best. I was one of the ones who always created a separate table/group for Key Measures, but your method of creating a folder for each table and putting the measures in the table outside the folder is brilliant and a lot more intuitive, since many times you're also using other fields from that table with the calculated measure. Just a superb course - thank you so much for this!!
@mariodemarchi2988
@mariodemarchi2988 3 жыл бұрын
Clear as crystal water !. Excellent communication skills and knowledge!. Thanks!
@MitchellPearson
@MitchellPearson 3 жыл бұрын
Thank you for the huge complement! Always glad to help.
@rebeccapatrick4852
@rebeccapatrick4852 6 ай бұрын
This DAX video is a masterpiece! I've learn't so much from this. I like how the course is broken down into segments and you explain what each measure is doing and how it does it. I have been available to comfortably follow the recording, and do the columns and measures myself, without having to pause or rewind to listen again. Please keep these coming! Thank you
@cbaide100
@cbaide100 3 жыл бұрын
The best Dax instructor ever! I've watched a lot of videos about DAX, including videos from DAX gurus and I can affirm this video is the best of all. Hard concepts are made easy to understand with clear examples, very good teaching technique. Kudos to the instructor!
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
This is incredible feedback, thank you Carlos, I am glad you found the video helpful. -Mitchell
@MohitKumar-ri3yv
@MohitKumar-ri3yv 2 жыл бұрын
Yes I agree with you that he's the best Dax instructor. Do you know where I can watch more of his videos?
@guacca
@guacca 8 күн бұрын
Any one else feel like they're stealing? I feel like I should be paying for this; it's so thorough, so complete.
@nikoskorakas7662
@nikoskorakas7662 18 күн бұрын
This is a masterpice! All core topics of DAX clearly explained!
@haoguoxuan411
@haoguoxuan411 2 жыл бұрын
Microsoft makes things complicated and you make Microsoft simple.
@antsbradley
@antsbradley Жыл бұрын
One of the best training videos I have seen regardless of subject!
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Glad you enjoyed it!
@fildude
@fildude 11 ай бұрын
Richard, great job with breaking down the concepts - I've been using Power BI and DAX and took this course as a refresher but I definitely learned SO MUCH MORE, I appreciate how you break down the concepts into manageable chunks and gave great examples as well :)
@arvindthiruvengadam9518
@arvindthiruvengadam9518 Жыл бұрын
Thank you for an excellent course. The pace at which you explained things was perfect, without any unnecessary repetitive statements. Examples were excellent, although I am using it for engineering data and not business related, I could relate your exams to my specific type of data.
@chigozienkwocha1940
@chigozienkwocha1940 Жыл бұрын
Wow! This is roughly three hours well spent. Thanks Mitchell and Pragmatic Works for this super awesome video. Really enjoyed every bit of it. Kudos!
@amnril
@amnril 3 жыл бұрын
I’m slowly working my way through this, excellent, thank you.
@aberaabebaw2104
@aberaabebaw2104 3 жыл бұрын
Great tutorial, this was intended for DAX but it is even explaining PowerBI report better than any video I saw on report design.
@jagadanandadasa4195
@jagadanandadasa4195 2 жыл бұрын
Amazing, followed the whole 3 hour video! Awesome, right level of difficulty and content for an intro video
@AkramAli-ve7fe
@AkramAli-ve7fe 2 жыл бұрын
Best of the best I'll say. I'm watching it twice. Feels great to listen. Feels great to understand. Many aha moments.
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Glad you enjoyed (:
@winstonloke2860
@winstonloke2860 2 жыл бұрын
better explanation than some paid courses.👍
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Thank you! Glad to help :)
@franciscovam57
@franciscovam57 Ай бұрын
Wow this is an amazing training. I am new in Power Bi and have found this the most helpful DAX training
@GeorgeKlucsarits
@GeorgeKlucsarits 3 жыл бұрын
Probably the best explanation of filter context I've seen so far. Happy to recommend it to some colleagues who are just starting to learn DAX.
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
Thanks George!
@irfandaud7380
@irfandaud7380 2 жыл бұрын
It was an outstanding lecture. Explanation was crip and clear. loved the style. Great Job MP
@sunjiulu
@sunjiulu 2 жыл бұрын
Mitchell Pearson! just wonderful!
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Thanks Jiulu and thanks for taking time to comment! -Mitchell Pearson
@krom820
@krom820 2 жыл бұрын
Excellent class! You were so easy to understand, although I have been working in PowerBI for a while now, so I'm sure that helped. But, I know I needed more understanding of DAX and you're helping me get there. Thank you so much!
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Thanks for watching!! Glad you enjoyed it.
@stoneage8810
@stoneage8810 Жыл бұрын
there are a lot of DAX experts online but not everyone can explain/teach clearly, or in a way thats easy for people to follow, amazing , thanks for the video
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Glad to help!
@elphasluyuku4167
@elphasluyuku4167 3 ай бұрын
This is the best DAX video i have encountered on this platform. You sir are incredible
@pariKil
@pariKil 3 жыл бұрын
What a great educational presentation! Thank you Mitchell for sharing your knowledge and making it easy to follow and understand . Your presentation was very much appreciated! Recommending it to all Power BI enthusiasts I know.
@MitchellPearson
@MitchellPearson 3 жыл бұрын
Thank you Fair, glad you enjoyed it and it was helpful!
@aescamilla
@aescamilla Жыл бұрын
Absolutely amazing 3 hrs. course, as many of you I come from the SQL world so DAX has always be confusing; this course cleared so many questions. Kudos to Mitchel Pearson for an extraordinary compilation of knowledge! Thank you so much, keep up the excellent work.
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Glad it was helpful!
@ianalvarez7953
@ianalvarez7953 Жыл бұрын
this is just amazing, straight to the point, well explained , with examples and real case scenarios. Well done!
@user-vy1ym1dl7g
@user-vy1ym1dl7g Ай бұрын
God bless you bro I have power bi exam tmr and you helped me lotss
@33squrl
@33squrl Жыл бұрын
This is the first video I've seen that explains DAX concepts this thoroughly and in a way I understand. I hope I find more of these. Thank you!
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Great to hear!
@remuslupinhp
@remuslupinhp 2 ай бұрын
I can't be more thankful enough. I have been looking for something to practice what I had learnt from the DAX book and a few courses I have done previously. But it's all too complicated if you don't have examples to practice on. This video does just that, it gives me examples to work with. I know a lot of this stuff but I am never confident when it comes to applying these concepts so this is where this tutorial comes in handy. You need to have initial background but after that, if you have to gain mastery you need practice and this is THE best video I have found for practicing. Kudos! You are doing some really awesome work!💕
@SantiagoZuluaga
@SantiagoZuluaga Жыл бұрын
Thank you very much Mitchel & Pragmatic Works for this amazing course. -Great examples (real world examples). -Great explanation. What a teacher! He shows experience and ability to explain. In the 99th percentile of the best tutorials I've seen on KZfaq. Coming from a Tableau user, I have to say that this video is GOLD. It's hard to find such a good explanation for a 'Filter Context' and all concepts in Time Inteligence (YTD Measures, Prior YTD Measures, etc). So again, Thank you!
@ashutoshgadgil8407
@ashutoshgadgil8407 Жыл бұрын
Probably one of the best DAX videos I have watched on youtube till now.
@gonzalofuste
@gonzalofuste 7 ай бұрын
Richard, I have to say that you are a great teacher, you explain concepts that could be difficult to understand in a clear and understandable way. You are very didactic and I learn a lot from your teachings.
@ypng9040
@ypng9040 3 ай бұрын
Huge thanks to PW and Mitchel for this wonderful tutorial, watching the ads as my way of saying thanks
@TheJbudimir
@TheJbudimir Жыл бұрын
Such a great course!! Impressed by how 3 hours went by, received so much information and yet, not feeling overwhelmed because everything was so well explained.
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Glad it was helpful!
@adiky
@adiky 3 жыл бұрын
So far the best DAX content ever I have come across. Nicely structured and to the point content.
@MitchellPearson
@MitchellPearson 3 жыл бұрын
That's a huge compliment! Thanks Aditya, I had a lot of fun.
@mhn17
@mhn17 Жыл бұрын
I read "Learn to Write DAX" of Matt Allington, and this video definitely consolidates my takes on the book. The concepts become much easier to understand when you start with Calculated Column and Row Context first.
@vandanpandya9587
@vandanpandya9587 4 ай бұрын
Thank you Mitchell for explaining DAX so intuitively. You helped me get a good grip on DAX functions.
@shellsd
@shellsd 2 жыл бұрын
Wow, cannot thank you enough for putting this course out there, and for free. Pragmatic is definitely the best when it comes to learning Power BI. THANK YOU!
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
That is an amazing compliment. Thank you!
@alibaig5940
@alibaig5940 3 жыл бұрын
wow! This is the best video on DAX/PowerBI I have come across. Been working with PowerBI 5 years but this clears up so many concepts in one go. Not sure why this is considered intro :) This really is PowerBI start to finish!
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
Thanks Ali, glad you found the video helpful!
@anthonynkem
@anthonynkem Жыл бұрын
I just cant hold back my appreciation to you guys. You are just awesome. Thank you for all the effort you put into your tutorials. This was really masterpiece.....:)
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Wow, thank you!
@rajkaur1736
@rajkaur1736 3 жыл бұрын
One thing I know, you can never go wrong with Pragmatic Works. I have been following you guys as a go-to when it comes to BI or now-Cloud BI for last 10 years, everything you guys do to stay ahead of the what's coming next in technology, your free resources, power-packed webinars - are truly marvelous.
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
Thank you for that kind comment, we appreciate your feedback and your follow!
@MoeBig50
@MoeBig50 7 ай бұрын
I watch this every time I need a refresher on DAX.
@MoeBig50
@MoeBig50 3 ай бұрын
Another refresher lol
@lyndseytan2268
@lyndseytan2268 2 жыл бұрын
Super trainer! I am a completely beginner of this DAX but you enlightened me. Thank you for sharing these wonderful session.
@idowualamiyo898
@idowualamiyo898 3 жыл бұрын
Great session, thanks to the Power BI master!
@MrARP96
@MrARP96 2 жыл бұрын
I think this is the single greatest tutorial video on a subject ever. Mad to see that such content is available for free. Fantastic bit of work.
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Glad it was helpful!
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Wow, that's awesome praise lol!! Thank you MrArp - Mitchell Pearson
@hayatibrahim4615
@hayatibrahim4615 Жыл бұрын
One of the best tutorial I ever watched on DAX.
@evangelinekiku7380
@evangelinekiku7380 2 жыл бұрын
Thank you very much for this course. I have learned so much. The explanation is very clear and precised. This will help me to understand DAX functions better. Please how can I access the exercise files?
@parastoomousavi8847
@parastoomousavi8847 Жыл бұрын
very DAX fluent teacher. Great video. Thanks
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Glad you liked it!
@websiteanalytics5473
@websiteanalytics5473 3 жыл бұрын
Chuck Norris can divide by zero !!! Hell yeah ! Great Video by the way, I wish I had seen this 12 months ago ! Will recommend to colleagues beginning their DAX journey.
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
Haha, thanks "Website Analytics" glad you enjoyed the video.
@michelleliu1181
@michelleliu1181 Жыл бұрын
I just have to leave a comment! This is the best DAX tutorial I have seen. I didn't expect that I'd be fully understanding of the concepts at the end of the day, and I did!! Thanks so much for the awesome explanation and demonstration.
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Wow, thanks!
@muriwangul.chinyerere5381
@muriwangul.chinyerere5381 Жыл бұрын
This has been the most informative lesson on DAX I have ever had. After this I'm redoing my current reports from scratch lol. Great stuff
@desoxx
@desoxx 3 жыл бұрын
Great training, excellent presentation!! Thank you Mitchell!
@MitchellPearson
@MitchellPearson 3 жыл бұрын
Thanks so much, I had a great time :)
@JenMayB
@JenMayB 3 ай бұрын
This is great. Finally understanding that the aggregate roll up of data is added to the DIMENSION tables using the navigation functions. I was missing that part. Thank you!
@aleksandaratanasov105l
@aleksandaratanasov105l 2 жыл бұрын
Bravo, the most friendly and usable lecture so far.
@efbsql1562
@efbsql1562 Жыл бұрын
The explanation of the concepts in DAX is really good. Thank you, Mitchell Pearson! I will definitely enroll in Pragmatic Works ODL in DAX soon!
@PragmaticWorks
@PragmaticWorks Жыл бұрын
My pleasure!
@nidhalmahjoubi7964
@nidhalmahjoubi7964 Жыл бұрын
After 30 minutes of watching this video I think it's not completely beginner friendly and it's for the more experienced people. I'll come back to this when I learn a bit more about DAX and Power BI as I enjoyed these 30 minutes despite struggling to grasp all these concepts
@fariheyd5406
@fariheyd5406 3 жыл бұрын
Hi Progmatic Works, I enjoyed every single minute of this video with perfect explanations of the context, best practical examples of senarios that a function can be applied and all technical know hows that mentioned. Thank you very much. The only thing I'd like to check is the version of DW of this video. I faced a number of issues when doing my own DAX coding, like the slicer for countries does have impact on measures like US sales or Fiscal YTD Sales does not function properly(Date table does not have a Date column but FullAltenateDate colum which is Data not DateTime. I appreciate if you could tell us which versions of Power BI and Adventure DW is being used in the video.
@kishangzp
@kishangzp Жыл бұрын
Wonderful session on Dax...! Those who want to be clear about the basic idea of the Dax with some used case.... please do watch this! Related Table 00:32:00 Switch 00:36:05 Calculate 00:49:20
@davehughes9905
@davehughes9905 Жыл бұрын
Richard, WOW some of the best teaching of a challenging topic I have ever seen. I'll be signing up for the boot camp as I have really enjoyed watching the 3 hours.
@sulaimonolayode1310
@sulaimonolayode1310 3 жыл бұрын
This is absolutely amazing video on DAX! Very useful for DAX beginners like me. Thanks so much Mitchel. Great job by Pragmatic Works
@MitchellPearson
@MitchellPearson 3 жыл бұрын
Thanks Sulaimon
@eerosiljander4622
@eerosiljander4622 2 жыл бұрын
Got DA-100. Thanks to you !
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Nice work!
@christianraouldjatio1738
@christianraouldjatio1738 Жыл бұрын
Mitchell is the best at explaining with supporting examples very advanced concepts in very simple words.
@sands7779
@sands7779 3 жыл бұрын
good, clear presentation on dax by Mitchell Pearson , Pragmatic Works, highly recommend 🌟🌟🌟🌟🌟
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
Thanks! -Mitchell
@muhammadsulaiman4276
@muhammadsulaiman4276 5 ай бұрын
You are simply great! I am a super user of PBI, yet I was counting a lot on Excel to prepare the datasets before exporting them to PBI. Now I can skip off such transitory phase (which needs double efforts and may cause some discrepancies) and make everything inside PBI. Really appreciated 🎉🎉
@mohanbabu9939
@mohanbabu9939 2 жыл бұрын
It's an amazing session, Thank you so much for publishing this over ..
@cristianchelu1563
@cristianchelu1563 2 жыл бұрын
Congrats! Tried other (paid) courses for DAX induction, no result; from your free tutorial I feel I am almost there :)
@muhammadazam8422
@muhammadazam8422 3 жыл бұрын
A fruit full session on DAX. Thanks
@folashadeolaitan6222
@folashadeolaitan6222 Жыл бұрын
Thank you Mitchell for the wonderful class, i am quite very new to DAX but was still able to follow along the explanations. I will continue to practice and will follow your personal KZfaq page for more awesome contents
@FiroozeSafaei
@FiroozeSafaei Жыл бұрын
I was totally new to Dax and besides the interesting things I learned from you, I got the kind of excitement that you have about Dax, like you have transferred your excitement to me as well and now I am eager to learn more and more about it. Thanks
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Awesome, thank you!
@angelamaecampo7807
@angelamaecampo7807 Жыл бұрын
This is such an amazing extensive and robust DAX session I've ever watched. Thank you for sharing.👍👍👍
@aziserak4743
@aziserak4743 2 жыл бұрын
Thank you so much you touched the important part of dax 🥰🥰
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Glad you enjoyed!
@alfonsogordillo9900
@alfonsogordillo9900 2 жыл бұрын
Thank you, for me this it was the best DAX presentation, I am preparing the DA-100 exam and now I am confidence with DAX part for my Certification of PowerBI
@xMastJedi
@xMastJedi 2 жыл бұрын
For CALENDAR function I am creating dynamic calendar, where I input just start date. End date is calculated. It's CALENDAR ( DATE (2016, 1, 1), TODAY() + 365 ) Works well. Like Stinger. Launch and forget :D
@justsomeguy1408
@justsomeguy1408 2 жыл бұрын
Very clear and concise explanations. I'm just starting out with Power BI and watching this boosted my understanding significantly. My models and reports are already improving. Thank you!
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Great to hear!
@BoBackfisch
@BoBackfisch Жыл бұрын
Thank you so much for your amazing tutorials. Every time I am thinking about a question it magically gets answered right away in the very next chapter or through the questions during the live session. I am very grateful, amazing job
@jamieelswick8399
@jamieelswick8399 3 жыл бұрын
Automagically... love it. This has been a phenomenal training!
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
Thanks Jamie! Glad you enjoyed the training!
@priyasharans
@priyasharans 2 жыл бұрын
Excellent training with great topics. Thank you.
@mashed4804
@mashed4804 6 ай бұрын
I wanted to take a moment to express my sincere appreciation for your explanation. Your insightful and articulate approach not only made the complex subject matter more accessible but also sparked a newfound understanding and curiosity within me. I wanted to learn DAX since many months and watched many videos but was not satisfied with them. This video made me understand, so well, thank you so much. I sometimes subscribe or like videos, but this is the first time I have commented on a video, what an explanation 👋👌💯
@HopeCastle2000
@HopeCastle2000 Жыл бұрын
This was an outstanding presentation. You cleared up a lot of things for me. Thank you!
@weipingjiao
@weipingjiao Ай бұрын
A big thank you to you Mitchell. Really enjoyed the class and learnt a lot so far.
@vergesslich82
@vergesslich82 2 жыл бұрын
This is a excellent training video, thank you!
@advent7324
@advent7324 Жыл бұрын
Did Dashboard in a Day with Pragmatic a couple of years ago. Really good day. But this tutorial was great and explanations terrific. Thanks for sharing your knowledge of Power BI
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Thank you for joining us and watching!
@virtualtour4u85
@virtualtour4u85 2 жыл бұрын
amazing lesson! this is very helpful. learned a lot
@ryanbowns1517
@ryanbowns1517 Жыл бұрын
Love this Video very new to PowerBI and DAX coming from a python background so it was hard to wrap my head around how filters did not have to specified in the calc if the measure was made outside of the column and a relationship between tables existed. I ended up changing a lot of my code to just use a simple Calculate( (total) , filter) expression instead of SUMX, if logic etc 😅
@MrJimpk1
@MrJimpk1 2 жыл бұрын
Excellent video, learned a lot and a big plus for explaining everything in simple terms 👍👍
@diabymamadou2190
@diabymamadou2190 Жыл бұрын
This video is one of best I have ever watched on DAX. Thank you for your great work.
@PragmaticWorks
@PragmaticWorks Жыл бұрын
Glad you liked it!
@rachelzhao6624
@rachelzhao6624 Жыл бұрын
really useful!!! I learned power bi from my last job, it was all a practical thing but no idea about basics and how it works. I learned many ways to let the work more efficient and processing time getting shorter. why not I did not check this video earlier??!?!?!?!
@dunni4920
@dunni4920 2 жыл бұрын
You are a great teacher, thank you so much.
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Thank you!
DAX Filter Context Basics [Full Course]
1:26:25
Pragmatic Works
Рет қаралды 32 М.
Visual Calculations in Power BI - DAX Made Easy! [Full Course]
1:30:40
Pragmatic Works
Рет қаралды 20 М.
Cute Barbie gadgets 🩷💛
01:00
TheSoul Music Family
Рет қаралды 72 МЛН
어른의 힘으로만 할 수 있는 버블티 마시는법
00:15
진영민yeongmin
Рет қаралды 7 МЛН
📊 How to use Power BI DAX - Tutorial
37:28
Kevin Stratvert
Рет қаралды 1 МЛН
Data Modeling for Power BI [Full Course] 📊
2:34:41
Pragmatic Works
Рет қаралды 3,1 МЛН
Full Power BI Guided Project | Microsoft Power BI for Beginners
42:37
Alex The Analyst
Рет қаралды 353 М.
Hands-On Power BI Tutorial 📊 Beginner to Pro 2023 Edition [Full Course] ⚡
3:02:18
Power BI Tutorial From Beginner to Pro ⚡ Desktop to Dashboard in 60 Minutes ⏰
1:03:31
DAX by examples
1:11:50
SQLBI
Рет қаралды 209 М.
Understanding Row Context in DAX using Power BI
19:47
Pragmatic Works
Рет қаралды 39 М.
Advanced Power BI Takeover!
2:56:16
Pragmatic Works
Рет қаралды 175 М.
Power BI DAX Tutorial - Beginner to Advanced [Full Course]
1:26:33
Pivotalstats
Рет қаралды 50 М.
Cute Barbie gadgets 🩷💛
01:00
TheSoul Music Family
Рет қаралды 72 МЛН