MIN

Returns the smallest value in the specified column

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:

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:

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! 🕵️‍♂️🔍