Скачать или смотреть 7. How Many 1997 Orders Beat the Average? | DAX Challenge Day 7

Welcome to Day 7 of the 21-Day Power BI DAX Challenge by Pavan Lalwani!

Today’s challenge is focused on sales performance in 1997.
We’ll solve this with a mix of FILTER, ADDCOLUMNS, AVERAGEX, and COUNTROWS to answer:

“How many orders in 1997 were above the average sales amount?”

🧠 What You’ll Learn:
1. Filtering data for a specific year (1997)
2. Adding calculated columns using ADDCOLUMNS
3. Calculating average order sales using AVERAGEX
4. Filtering orders above that average
5. Counting the total qualifying records with COUNTROWS

📚 Join the challenge and get datasets + solutions
👉 https://learn.pavanlalwani.com/s/page...

🎓Want to master Power BI end-to-end?
👉 Enroll for Power BI Courses at 30% Off (Use: ACTION30)
👉 Start learning now:
🔹Power BI: https://learn.pavanlalwani.com/course...
🔹Projects: https://learn.pavanlalwani.com/course...
🔹DAX: https://learn.pavanlalwani.com/course...

⏱️ Timestamps:
0:08 – Welcome to Challenge Day 7
0:17 – Question: 1997 orders above avg sales
0:31 – Step-by-step breakdown of solution
1:06 – Using SUMX to get total sales
1:43 – Filtering orders by year 1997
2:14 – Adding sales column with ADDCOLUMNS
3:21 – Calculating average with AVERAGEX
4:03 – Finding orders with sales above avg
5:04 – Counting rows using COUNTROWS
6:05 – Final result: 19 orders
6:30 – Preview of Challenge 8



#PowerBI #DAXChallenge #PavanLalwani #LearnWithPavan #PowerBIProjects #PowerBITraining #AVERAGEX #ADDCOLUMNS #COUNTROWS #SalesAnalysis #BusinessAnalytics #PowerBIForBeginners #MicrosoftPowerBI #RealWorldDAX #DataAnalytics #SalesInsights #DashboardTips #BIUseCases #PowerBIDAX #AnalyticsChallenge