Beginner Power BI DAX Functions Tutorial [Full Course]

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.

-------------------------------------------------

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

After you finish this course:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

#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

[rishabhvashistha]

DAX cant be explained better, Your DAX and Modelling video is the reason behind the appreciation I get in my office.

[kimrainman]

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 ✔

[dpoort]

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!

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

[chisomnkoloagu]

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.

[jonlong]

As of today I’ve watched the first 45 minutes (calculated columns) about 6 times. Haven’t even gone further yet. After watching it each time I’ve gone back and played around with some of my own data and each time I have a bit of Eureka moment. Nowhere close to being DAX proficient yet, but if anyone is struggling to make sense of what Mitch is saying, keep persevering. It’s starting to make a bit of sense.

[fawadahmadi]

I don't know how to appreciate it. Your are doing great job for Power BI Developers.

[davidlydike]

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.

[Superok]

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!

[mmorpe]

Mitchel, I am new to DAX, and yet I remained glued to your session for complete 3 hrs. You are simply awesome.

[jesse]

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

[cbaide]

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!

[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

[rajatbi]

I saw many Power BI Videos, but your training skills are really awesome.

[houstonvanhoy]

The first time that I viewed this, I learned some stuff, all of it new.
The second time that I viewed this, I understood the rest.
In both cases, I turned the speed down to .75 in order to keep up.
The third time that I will view this, I will probably turn the speed back to 1.00.
In any case, the material is sinking in. Thank you, Mitchell. I Look forward to
seeing much more of your content. 👍

[mariodemarchi]

Clear as crystal water !. Excellent communication skills and knowledge!. Thanks!

[rajkaur]

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.

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

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

[alfonsogordillo]

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