What you'll learn
Understand Context Transition Once and For All
Understand Why Your DAX Measures Return Wrong Results
Master CALCULATE Function to Write Any Calculations You Need
Master Difficult Concepts Like Row Context and Filter Context
Understand When to Use RELATED and When to Rely on Relationships
Learn Step-by-Step What Goes on Behind the Scenes when DAX Calculates Formulas
Master DAX in Power BI as well
Requirements
Basic Knowledge about Power Pivot and DAX
Know what Measures Are and How to Write Them
Knowledge About Measures Using SUMX & SUM
Description
If you've completed a basic Power BI or Excel Power Pivot DAX course and you find yourself struggling with DAX concepts, then this is your course. Specifically if you struggle with
- Context Transition: What does it mean and how do you know it's happening?
- Row & Filter context: What are they and why are they important?
- CALCULATE function: How does it work and why is it so powerful?
- FILTER function: What's the use of this function and how can you properly use it
- When to use RELATED function and when to rely on relationships
- When to use ITERATOR functions and when to use the standard version of the function
- How can you debug your measure and formulas to see what's going on in the background?
All of these is covered in this compact DAX course!
You see, to create professional data models in Power BI and Excel Power Pivot, you need to learn DAX.
Here's the problem...
DAX can get difficult.
Most courses focus on the technical aspects only instead of real-life applications. Therefore, many people haven't explored what it has to offer!
They continue doing things the old "manual" way. Or the "complex" way with difficult formulas.
And that's why I created this course!
This Advanced DAX course explains technical concepts in SIMPLE terms. It's a course addressed to Excel users and not IT Developers.
I broke down the concepts in unique ways so you can visualize what's happening at each stage. Because complicated explanations cost time and knowledge!
And something else you may not know ...
Data modelling and DAX is not just for Excel but it's also a skill you need to have for Power BI. So, you learn 1 feature and you can apply it to 2 different apps. In fact, the 2 applications most used in companies today.
Come join me in this course and finally master difficult DAX concepts!
Who this course is for
You have already completed a DAX course but struggle with understanding some of the important concepts
Homepage

https://www.udemy.com/course/advanced-dax