---
title: MIN
description: Learn how to use the MIN function in Infoveave to find the smallest value within a dataset. This guide covers syntax, examples, and practical applications.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# MIN

The MIN function in Infoveave finds the minimum (smallest) value within a column (Measure).

## Applicable to

* Calculated Columns
* Expressions

## Return Value

* The smallest value in the specified column.

## Remark

* MIN determines the smallest value in a dataset.
* MIN returns the minimum value, excluding nulls and blanks.
* MIN can be used across Dates, Strings, and Numbers.

## Syntax

```
MIN(<expression>)
```

<Aside>
* Applied to a date column, MIN returns the earliest date.
* Applied to string values, MIN returns the first value alphabetically.
* Applied to a Boolean, MIN returns FALSE.
</Aside>

## MIN in Board Expression

<Aside>
Expressions add visual effects to your dashboard through widget-specific conditions. They do not manage or modify data.
</Aside>

| Parameter     | Description                                                                                   |
|---------------|-----------------------------------------------------------------------------------------------|
| Expression    | A placeholder in a function replaced with actual widget and measure names.                    |
| Widget Name   | The specific name of the widget used for data visualization in the Infoboard.                 |
| Measure       | The name of the measure displayed or analyzed using the widget.                               |

Steps to Use MIN

<Steps>
1. Write the MIN function. For instance `MIN(<expression>)`
2. Replace `<expression>` with `'Widget Name'[Measure]`. Replace **Widget Name** with your widget's name and **Measure** with the measure name.
3. To learn how to configure an Expression in Infoveave, visit [Configure Expression](/insights-v8/advanced-configuration/#configuring-expressions).
</Steps>

<div role="alert">

**Scenario** Identify the product with the lowest price (above $50) from your 'Product Prices' dataset.

**Scenario Details**

* **Dashboard Name** E-commerce Bargain Finder
* **Widget Name** Product Prices
* **Measure Name** Price

**Objective** Find the product with the minimum price and check if it doesn't exceed a certain threshold.

* You can use the MIN function like this

```
MIN('Product Prices'[Price]) <= 50
```
</div>

## MIN in Calculated Columns

| Parameter     | Description                                                                         |
|---------------|-------------------------------------------------------------------------------------|
| Expression    | A placeholder in a function replaced with column names.                             |
| Column Name   | The name of the column containing the values you want to analyze.                   |

Steps to Use MIN in Calculated Columns

<Steps>
1. Write the MIN function. For instance `MIN(<expression>)`
2. Replace `<expression>` with `[Column Name]` in the dataset.
3. To learn how to use Infoveave functions in calculated columns, visit [Add Calculated Column](/studio-v8/datasources/calculated-columns-datasource/) under Sources.
</Steps>

<div role="alert">

**Objective** Find the minimum value in the 'MARKET PRICE' column.

| ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY |
|------------|---------|----------|------------|--------------|----------|
| 2024-01-03 | Brazil  | Baby Food | 38.41      | 43.7874      | 2        |
| 2024-01-07 | Japan   | Spices   | 45.56      | 50.8155      | 20       |
|            | Japan   |          |            | 43.7874      | 10       |
| 2024-01-18 |         |          |            | 32.3019      | 4        |
| 2024-01-22 | Brazil  | Cosmetics| 28.335     | 23.0109      | 7        |
| 2024-01-26 | Canada  |          | 20.185     | 23.0109      | 9        |
| 2024-01-04 | France  | Cereal   | 25.26      | 28.7964      | 9        |
| 2024-01-09 | Brazil  | Cereal   | 44.575     | 50.8155      | 8        |
| 2024-01-14 | Brazil  | Snacks   | 20.185     |              | 4        |
|            | Brazil  | Cosmetics| 40.485     | 46.1529      | 2        |

* You can use the MIN function like this

```
MIN([MARKET PRICE])
```

The new calculated column "Min Market Price" will return 23.0109.

| ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY | MIN MARKET PRICE |
|------------|---------|----------|------------|--------------|----------|------------------|
| 03-01-2024 | Brazil  | Baby Food | 38.41      | 43.7874      | 2        | 23.0109          |
| 07-01-2024 | Japan   | Spices   | 45.56      | 50.8155      | 20       | 23.0109          |
|            | Japan   |          |            | 43.7874      | 10       | 23.0109          |
| 18-01-2024 |         |          |            | 32.3019      | 4        | 23.0109          |
| 22-01-2024 | Brazil  | Cosmetics| 28.335     | 23.0109      | 7        | 23.0109          |
| 26-01-2024 | Canada  |          | 20.185     | 23.0109      | 9        | 23.0109          |
| 04-01-2024 | France  | Cereal   | 25.26      | 28.7964      | 9        | 23.0109          |
| 09-01-2024 | Brazil  | Cereal   | 44.575     | 50.8155      | 8        | 23.0109          |
| 14-01-2024 | Brazil  | Snacks   | 20.185     |              | 4        | 23.0109          |
|            | Brazil  | Cosmetics| 40.485     | 46.1529      | 2        |
</div>