MAX

The MAX function in Infoveave finds the maximum (largest) value in a specified column (Measure).

Applicable to

• Calculated Columns
• Expressions

Return Value

• The largest value in the specified column.

Remark

• MAX is useful for identifying the maximum value in a dataset (e.g., highest sales, longest duration).
• MAX returns the maximum value, excluding nulls and blanks.
• MAX can be used with Dates, Strings, and Numbers.

Syntax

MAX(<expression>)

Tip

*With a date column, MAX returns the latest date. *With string values, MAX returns the last value alphabetically. *With Booleans, MAX returns TRUE.

MAX in Board Expression

Note

Expressions add visual effects to your dashboard via widget-specific conditions. They don’t manage or modify data.

Parameters

Parameter	Description
Expression	Placeholder replaced with actual widget and measure names.
Widget Name	Specific name of the widget used for data visualization in the Infoboard.
Measure	Name of the measure displayed or analyzed using the widget.

1. Write the MAX function MAX(<expression>)
2. Replace <expression> with 'Widget Name'[Measure]
3. Replace Widget Name with your widget’s name and Measure with the measure name.
4. For configuring Expressions in Infoveave, see Configure Expression.

MAX in Calculated Columns

Parameter	Description
Expression	Placeholder replaced with column names.
Column Name	Name of the column containing the values you want to analyze.

1. Write the MAX function MAX(<expression>)
2. Replace <expression> with [Column Name] in the dataset.
3. For using Infoveave functions in calculated columns, see Add Calculated Column under Sources.

Example

Scenario Finding the maximum product price (under 100) on an e-commerce platform.

Scenario Details

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

Objective Find the maximum price and check if it exceeds 100.

MAX('Product Proces'[Price]) <= 100

Example

Objective Find the maximum “UNIT PRICE” in a sales dataset.

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

MAX([UNIT PRICE])

The calculated column “Max Unit Price” will return 45.56.

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