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/pages/da21days
(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/courses/Power-BI-Specialization-63a05686e4b0a7b1ab4dfc8d

⏱ 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