Скачать или смотреть 14. Power BI DAX Challenge | Find Top Customer by Sales in 1997

Welcome to Day 14 of the 21-Day DAX Challenge!

💡 Use code: YouTube20 to get 20% OFF on our full Power BI and DAX course!
🔗 Enroll Now: https://learn.pavanlalwani.com/course

In this video, we answer a key business question:
"Which customer generated the highest sales in 1997?"

📊 Perfect for historical analysis and real-life reporting in Power BI.

👉 What you'll learn:
Create a DAX virtual table
Filter data for a specific year
Find the max sales value
Identify the top customer by sales
Use LOOKUPVALUE to fetch names from IDs


📚 Haven’t enrolled yet?
👉 Join the 21-Day DAX Challenge → https://learn.pavanlalwani.com/s/page...
(Enroll to access all datasets, submissions, and bonus content)

🔰 New to Power BI or DAX? Don’t worry! Start with the basics here:
📘 Beginner Power BI Course Start Here: https://learn.pavanlalwani.com/course...

⏱️ Timestamps:
0:08 - Welcome to Day 14
0:16 - Business Question: Top customer in 1997
0:43 - Step 1: Virtual table setup (Customer ID + Sales)
1:36 - Step 2: Filter by year (OrderDate = 1997)
1:59 - Step 3: Get Max sales from virtual table
2:19 - Step 4: Get Customer ID with max sales
2:54 - Step 5: Use LOOKUPVALUE to find company name
3:39 - Final Answer: Taylor Swift
4:20 - Teaser for Day 15: Most orders in a single month


#powerbi #daxchallenge #powerbidax #dataanalytics #businessintelligence #pavanlalwani #topcustomer #salesanalytics #powerbidax