Welcome to Day 17 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 takes the longest time to ship orders on average?

In this challenge, you'll learn to write efficient and clean DAX code to detect delays in the shipping process:

Create a virtual table using ADDCOLUMNS and AVERAGEX
Use DATEDIFF to calculate shipping delay
Sanitize your data using FILTER
Use MAXX to identify the maximum delay
Use LOOKUPVALUE to fetch the employee name from the ID

By the end of this video, you’ll be able to pinpoint the slowest shipper using pure DAX logic a vital business insight for performance management!

Next Challenge Preview – Day 18:
Which employee joined the company the earliest?

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

⏱ Timestamps:
00:00 - Introduction to Day 17 of the DAX Challenge
00:08 - Business problem: Longest average shipping delay
00:50 - Step 1: Create a table with employee-wise shipping delay
01:37 - Use AVERAGEX with DATEDIFF for average calculation
02:06 - Sanitize data using FILTER on order and ship dates
03:40 - Step 2: Get the max average shipping delay using MAXX
04:00 - Step 3: Find the employee ID with the max delay
05:01 - Step 4: Use LOOKUPVALUE to return employee name
05:23 - Final Result: Steve Jobs is the slowest shipper
06:07 - Day 18 Preview: Employee with earliest joining date
06:15 - Wrap-up and next steps

#PowerBI #DAX #DAXChallenge #LearnDAX #BusinessIntelligence #ShippingDelay #EmployeePerformance #OrderFulfillment #PowerBITutorial #DAXLogic #PowerBIBeginners