MIN and MAX in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to know the minimum and maximum sales amounts for each product category in the last quarter.

📊 Data: You have a sales dataset with columns: Date, Product Category, Sales Amount.

🎯 Deliverable: Create a report showing each product category with its minimum and maximum sales amounts for the last quarter.

Sample Data

Date	Product Category	Sales Amount
2024-01-15	Electronics	1200
2024-02-10	Electronics	1500
2024-03-05	Electronics	1100
2024-01-20	Clothing	500
2024-02-15	Clothing	700
2024-03-10	Clothing	650
2024-01-25	Home Goods	800
2024-02-20	Home Goods	900
2024-03-15	Home Goods	850

1

Step 1: Filter the data to include only sales from the last quarter (January to March 2024).

Use Power BI filter on Date column: Date >= DATE(2024,1,1) and Date <= DATE(2024,3,31)

Expected Result

Filtered data contains only sales from January, February, and March 2024.

2

Step 2: Create a measure to calculate the minimum sales amount per product category.

Min Sales = MIN('Sales'[Sales Amount])

Expected Result

Measure returns the smallest sales amount for the selected category.

3

Step 3: Create a measure to calculate the maximum sales amount per product category.

Max Sales = MAX('Sales'[Sales Amount])

Expected Result

Measure returns the largest sales amount for the selected category.

4

Step 4: Create a table visual in Power BI with Product Category as rows, and add Min Sales and Max Sales measures as values.

Table visual configuration: Rows = 'Sales'[Product Category], Values = Min Sales, Max Sales

Expected Result

Table shows each product category with its minimum and maximum sales amounts for the last quarter.

Final Result

Product Category | Min Sales | Max Sales
-----------------|-----------|----------
Electronics      | 1100      | 1500     
Clothing         | 500       | 700      
Home Goods       | 800       | 900      

✓Electronics category had sales ranging from 1100 to 1500.

✓Clothing category had the lowest minimum sales of 500.

✓Home Goods category sales ranged between 800 and 900.

Bonus Challenge

Create a visual that shows the minimum and maximum sales amounts over time for each product category.

Show Hint

Use a line chart with Date on the x-axis, and create two measures for Min and Max sales filtered by date and category.