MIN

The MIN function returns the smallest number from a set of values. It evaluates the provided numbers or node references and identifies the lowest value among them. This function is commonly used in data analysis to determine minimum values, lower limits, or least-performing results within a dataset.

Syntax

MIN(value1, [value2], ...)

Arguments

  • value1: The first number, array, or reference containing numeric values.
  • value2, ... (Optional): Additional numbers, arrays, or references containing numeric values.

Return value

Returns the smallest value from the specified arguments.

Example

MIN(Q1.Units, Q2.Units, Q3.Units, Q4.Units)

In the example below, the Min Unit measure is created using the MIN function, which returns the smallest unit value across the four quarters.

Excel Equivalent

MIN

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.