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/pages/21-days-dax-challenge

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/courses/Power-BI-Specialization-63a05686e4b0a7b1ab4dfc8d
Projects: https://learn.pavanlalwani.com/courses/PowerBi-Project-66a0a86c8e265517873c0c85
DAX: https://learn.pavanlalwani.com/courses/Microsoft-Power-BI-DAX-686b9f59bd8e322a4efb3109

⏱ 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