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>)

Note

• 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.

MIN in Board Expression

Note

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

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

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.

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

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

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 under Sources.

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