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

In today’s challenge, we answer a powerful business question using DAX:
"How much of our sales came from discontinued products?"

This is a real-world case where companies like Microsoft may analyze whether discontinuing certain products was a mistake especially if they contributed a significant portion of revenue.

Not enrolled yet?
Join the full 21-Day DAX Challenge →
https://learn.pavanlalwani.com/s/pages/21-days-dax-challenge

Want to master Power BI end-to-end?
Enroll for Power BI Courses at 30% Off (Use: ACTION30)
https://learn.pavanlalwani.com/s/store

Timestamps:
0:08 – Welcome to Challenge Day 6
0:11 – Understanding the sales % from discontinued products
0:20 – Using DIVIDE to calculate percentage
0:23 – Calculating total sales using quantity × unit price
0:31 – Filtering discontinued = TRUE
3:09 – Getting total & discontinued sales
3:25 – Why this question matters in real life
3:48 – Writing the DAX measure with DIVIDE
4:19 – Converting result to percentage format
4:26 – Final result: 14% of sales
4:31 – Business insight: Should discontinued products return?
4:52 – Challenge 7 Question

#PowerBI #DAXChallenge #LearnWithPavan #PavanLalwani #PowerBIChallenge #PowerBIForBeginners #DAXTutorial #BusinessIntelligence #TOPNDAX #SelectedValue #AdvancedDAX #RealWorldDAX #DAXPractice #PowerBITraining #PowerBIProjects #LearnPowerBI #DashboardBuilding #analyticschallenge