Скачать или смотреть 5. What’s the Avg Price of Discontinued Products? | DAX Challenge Day 5

Welcome to Day 5 of the 21-Day Power BI DAX Challenge with Pavan Lalwani!

In this video, we answer a common product analytics question using DAX:
"What is the average unit price of discontinued products?"

📚 Not enrolled yet? Join now to access:
👉 https://learn.pavanlalwani.com/s/page...

✅ Daily problem statements
✅ Datasets & submission links
✅ Bonus DAX mini-course

🧠 What you’ll learn in this video:
1. Use of AVERAGEX and FILTER in DAX
2. Filtering for discontinued products (TRUE)
3. How to calculate custom average using expressions
4. Difference between implicit and explicit measures
5. Creating logic for both discontinued and active products

📌 This challenge teaches real-world thinking with calculated measures and conditions key for analysts and dashboard developers.

👉 Learn the complete Advanced Power BI DAX Course
🎓 https://learn.pavanlalwani.com/course...

👉Learn the complete Power BI course from scratch:
🎓https://learn.pavanlalwani.com/course...

⏱️ Timestamps:
0:08 – Welcome to Challenge 5
0:10 – The question: Avg price of discontinued products
0:27 – Understanding the product table
0:39 – Identifying TRUE/FALSE for discontinued items
1:12 – Calculating average using drag-and-drop
1:40 – Now solving using DAX
2:14 – Writing AVERAGEX with FILTER
2:53 – Calculating average on filtered table
3:37 – Validating the result (889)
3:52 – Understanding filters & measures
4:14 – Modifying for continued products
4:31 – Summary of Challenge 5
4:38 – Preview of Challenge 6: % of sales from discontinued products




#PowerBI #DAXChallenge #LearnWithPavan #PavanLalwani #PowerBIChallenge #AVERAGEX #FILTERDAX #PowerBIForBeginners #DiscontinuedProducts #PowerBIProjects #RealWorldDAX #DAXPractice #BusinessAnalytics #LearnPowerBI #DataModeling #PowerBITraining #PowerBIIndia #DataDrivenDecisions #BIUseCase #PowerBIMeasures