DAX Filter - EARLIEST function

Description

Returns the current value of the specified column in an outer evaluation pass of the specified column.

Syntax

EARLIEST (<column>) 

Parameters

Return Value

The current value of row, from column, at the outer evaluation pass.

Remarks

The EARLIEST function is similar to EARLIER, in which you can also specify the level of recursion.

The Results of Earliest and Earlier functions will be the same, if the parameter number of Earlier function is omitted or is set to 1.

Example

If you have a table Sales with sales data, you can create a calculated column with the ranks of the Sales Amount values as follows −

= COUNTROWS ( 
   FILTER (Sales, EARLIEST (Sales[Sales Amount])>Sales[Sales Amount])
)+1