How we can help you?
DAX Guide - Data Analysis Expressions
Average Data
MIN
What it does?
Returns the smallest value in the specified column
Syntax
MIN([Column])
Returns
A single value (the smallest number).
What is the MIN Function?
The MIN function in DAX is like a detective on a mission to find the smallest treasure in a pile—it identifies the lowest value in a dataset! Whether you’re looking for the least expensive item in your inventory or the minimum score in a game, MIN is your trusty tool for uncovering those hidden low points!
Example 1: Lowest Temperature Recorded
Imagine you’re tracking temperatures in your city over a week. Here’s how your temperature data might look:
|
Day |
Temperature (°C) |
|
Monday |
25 |
|
Tuesday |
22 |
|
Wednesday |
28 |
|
Thursday |
19 |
|
Friday |
24 |
To find the lowest temperature recorded during the week, you’d use the MIN function like this
Min Temperature =
MIN(WeatherData[Temperature (°C)])
So, what was the coldest day? The minimum temperature is 19°C! ❄️🌡️
Example 2: Lowest Price of a Product
Now, let’s say you’re managing a retail store and want to find the lowest price of an item in your inventory. Here’s how your product price data might look:
|
Product Name |
Price ($) |
|
Blender |
45 |
|
Toaster |
25 |
|
Microwave |
75 |
|
Coffee Maker |
50 |
|
Slow Cooker |
30 |
To find the lowest price among these appliances, you would use the MIN function like this:
Min Appliance Price = MIN(ApplianceData[Price ($)])
Conclusion: Discover the Minimum with MIN!
The MIN function in DAX is your go-to tool for unearthing the smallest values in your datasets. Whether you’re seeking the lowest price on household appliances or the minimum score in a game, MIN helps you find those hidden lows!
So, don’t miss out—let’s start digging for those minimum values with the MIN function! 🕵️♂️🔍