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/19tBqW4XxShuwhVU1cgnQ2Q8xue)

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

👉 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-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Discord: prag.works/yt-discord
✔️Facebook: facebook.com/pragmaticworks/
✔️Instagram: instagram.com/pragmatic.works
✔️LinkedIn: linkedin.com/company/pragmaticworks
✔️YouTube: youtube.com/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

• Beginner Power BI DAX Functions Tutorial [Full Course] ( Download)
• Power BI DAX Tutorial - Beginner to Advanced [Full Course] ( Download)
• Learn DAX Fundamentals in 10 Minutes | Step-by-Step Guide ( Download)
• 📊 How to use Power BI DAX - Tutorial ( Download)
• Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡ ( Download)
• [[ 3 HOURS ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - { End to End } Full Course ( Download)
• [[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit ( Download)
• ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024) ( Download)
• No More DAX Power BI’s NEW Feature Explained (File Included) ( Download)
• Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included) ( Download)
• Complete DAX Course - From Basics to the Advanced Level | DAX Tutorial | BI Consulting Pro| Power BI ( Download)
• DAX CALCULATE Function Made Easy to Understand (just one word) ( Download)
• Power BI Full Course in 8 Hours | Power BI Tutorial for Beginners | @PavanLalwani ( Download)
• Power BI DAX Tutorial | How to use DAX functions with Examples | Beginners | Power BI Tutorial ( Download)
• Power BI Full Course - Learn Power BI in 4 Hours | Power BI Tutorial for Beginners | Edureka ( Download)