DAX Aggregation - MINX function

Description

Returns the smallest numeric value that results from evaluating an expression for each row of a table.

Syntax

MINX (<table>, <expression>)

Parameters

Sr.No. Parameter & Description
1

table

The table containing the rows for which the expression will be evaluated.
2

expression

The expression to be evaluated for each row of the table.

Return Value

Returns a decimal number.

Remarks

The MINX function evaluates the results of the expression according to the following rules −

  • Only numbers are counted. If the expression does not result in a number, MINX returns 0 (zero).
  • Empty cells, logical values and text values are ignored. Numbers represented as text are treated as text.

Example

= MINX (East_Sales,East_Sales[No. of Units]*East_Sales[Unit Price])
dax_functions_aggregation.htm
Advertisements