Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Bonus: DAX Made Easy
What this bonus contains
🙋♀️ READ THIS FIRST
Section 1: Welcome and Introduction
Data Intro and What You Achieve (4:31)
🛣️ Your Roadmap and Course Notes
🔻Download Workbooks & Data Overview
Useful Power Pivot Settings: Adjust Default Layout, Pivot Table settings & more (4:56)
Section 2: Data Compression & Smart Tips
Workbook Info & Notes
Setup the Model with a Separate Measures Table (Hidden Tip) (7:54)
Handling Drill To for Separate Measures Table
DAX Columnar Database & the Advantages it Brings (5:38)
Data Compression: How to Optimize Your Data Model with Smart Decisions (4:26)
🤔 Quiz
📝 Key Takeaways: Data Compression
Section 3: Evaluation Context & Relationships
Filter Context, Relationships & Grand Totals (9:00)
💪 CHALLENGE: Filter Context - Calculate Last Day of Sales for Each Month (4:45)
Concept of Expanded Tables (Become Pro) (7:01)
RELATED & RELATEDTABLE (When to Use These) (7:15)
Iterator Functions: When to Iterate & Use Related (SUMX vs SUM) (6:34)
Row Context: The Skeleton Underneath (6:54)
💪 CHALLENGE: Find the Mistake! DAX Function is Wrong! (6:39)
📝 Key Takeaways: Evaluation Context
Section 4: DAX Table Functions & Useful Accompanying Functions
Filter Function to Restrict the Filter Context (7:49)
💪 CHALLENGE: How Many Orders Below Retail Price? (5:55)
ALL Function with FILTER to Unfilter (8:32)
FILTER Function & Filter Context Interaction (Become Pro) (9:56)
Use Variables for More Clarity
VALUES & HASONEVALUE Function (8:55)
CONCATENATEX Function to Show Slicer Selection (Become Pro) (7:58)
💪 CHALLENGE: Get a List of Sales Dates for Each Product (4:45)
📝 Key Takeaways: DAX Functions
Section 5: CALCULATE Function
CALCULATE Function: Let's Review the Basics (4:34)
How to Visualize the Behavior of CALCULATE (8:06)
How CALCULATE Overwrites Existing Filters - KEEPFILTERS & FILTER(ALL) Combo (7:03)
OR, AND Conditions in CALCULATE (7:40)
CALCULATE with OR Condition from Multiple Columns (5:16)
Behavior of ALL in CALCULATE & Why Context Matters (Become Pro) (9:04)
ALLEXCEPT & ALLSELECTED in CALCULATE (Become Pro) (6:04)
Measures Based on Dynamic Thresholds (Disconnected Tables) - Become Pro (9:39)
Using Aggregation Functions in CALCULATE Filter (Unique Customers To Date) (9:00)
Using Variables for Complex Calculations (7:30)
💪 CHALLENGE: Find Last Follower Count (Value for Last Date) (6:54)
🤔 Quiz
📝 CALCULATE: Key Takeaways (8:21)
Section 6: Context Transition
Context Transition Explained with a Simple Example (Become Pro) (7:15)
When and How to Avoid Context Transition (3:38)
Where You NEED Context Transition (5:04)
💪 CHALLENGE: Maximum & Average Daily Sales (5:52)
Hidden Secret of Measures & Context Transition in Calculated Columns (6:36)
💪 CHALLENGE: Explain Why this Measure Returns Wrong Results (7:05)
📝 Key Takeaways: Context Transition
Section 7: Practical Advanced Calculations
What you Learn: Practical Advanced Calculations (1:26)
DAX Studio & Visualizing Tables (7:55)
TOPN Function (Sales of Top 3 Products) (7:25)
TOPN - Differentiate Between Ties (5:47)
Find Date with Highest Sales (CONCATENATEX & TOPN) (5:57)
🎁 BONUS: ADDCOLUMNS Function in DAX Studio (2:43)
Get Product Name with Highest Sales (5:53)
💪 CHALLENGE: Get the Customer Number with Highest Sales
RANKX Function for Dynamic Ranking (10:36)
Ranking Multiple Columns: CROSSJOIN Function (Become Pro) (3:25)
Many to One Side Calculations: Distinct Count of Sales City by Month (6:01)
💪 CHALLENGE: Distinct Count of Product Category by Month (Based on Sales)
📝 Key Takeaways: Advanced Calculations
Final Words
🎇 Wrapping up & What You've Achieved (1:31)
💪 CHALLENGE: Filter Context - Calculate Last Day of Sales for Each Month
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock