Welcome to Day 16 of the 21-Day DAX Challenge by Pavan Lalwani Academy!

Use code: YouTube20 to get 20% OFF on our full DAX course!
Enroll Now: https://learn.pavanlalwani.com/course

Not part of the challenge yet?
Join here: https://learn.pavanlalwani.com/s/page

Today’s Focus:
Which employee has the highest average sales per order?
In this challenge, we’ll solve it step-by-step using clean and powerful DAX logic:
Create a virtual table using ADDCOLUMNS
Calculate average order value using AVERAGEX
Use MAXX and FILTER to detect the top performer
Use LOOKUPVALUE to fetch the employee name dynamically

Next Challenge Preview – Day 17:
Which employee takes the longest time to ship orders on average?

Subscribe to stay updated: Learn AI. Automate Everything.

Follow Us for More:
Website: learn.pavanlalwani.com
Email: [email protected]
Instagram: https://www.instagram.com/pavanlalwani/?hl=en


⏱ Timestamps:
00:00 - Introduction to Day 16 of the DAX Challenge
00:10 - Challenge Overview: Who has the highest average sales per order?
00:21 - DAX Logic Breakdown Explained
00:27 - Step 1: Create a virtual table using ADDCOLUMNS and AVERAGEX
01:26 - Using the Total Sales measure inside the virtual table
02:29 - Step 2: Find the maximum average order value using MAXX
02:57 - Step 3: Filter table to get the employee with top average
03:40 - Extracting Employee ID using FILTER
03:48 - Step 4: Use LOOKUPVALUE to return the employee name
04:27 - Final Result: Tim Cook has the highest average order value
04:56 - Day 17 Preview: Employee with longest average shipping time
05:06 - Wrap-up and next steps

#PowerBI #DAX #DAXChallenge #LearnDAX #BusinessIntelligence #EmployeePerformance #ShippingAnalysis #OrderShipping #DAXLogic#PowerBITutorial #PowerBIBeginners