17. Who Delays the Most?⏳ DAX Reveals It | Day 17

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:   / 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

#powerbitutorialforbeginners #powerbi #powerbifullcourseplaylist #powerbitutorial #powerbifullcourse #pavanlalwanipowerbi #excelfullcourse #powerbidashboard #copilot #howtocreatedashboardinpowerbi #powerbicourse #drillthroughbuttonpowerbi #powerbipavanlalwani #powerbi #msexcelfullcourse #PowerBI #DAX #DAXChallenge #LearnDAX #BusinessIntelligence #ShippingDelay #EmployeePerformance #OrderFulfillment #PowerBITutorial #DAXLogic #PowerBIBeginners