How does the EARLIEST function (DAX) work?

The EARLIEST function (DAX) returns the current value of the specified column in an outer evaluation pass of the specified column.

EARLIEST Formula Syntax

EARLIEST(
     <column>
)

How do you use the EARLIEST function?

The EARLIEST function retrieves the value from the outermost row context. It is recommended using variable (VAR) saving the value when it is still accessible, before a new row context hides the required row context to access the desired value.

Related Blog Posts

Related Support Forum Posts

Comparing New vs Lost vs Steady Customers over Multiple Years – Customer Churn Examples – Advanced DAX
Not Registered in Last 6 Months
Calculating Project Payback Period using DAX

Considerations when using the EARLIEST function

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.

Related Video Tutorials

Formula examples using the EARLIEST function

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

= COUNTROWS( FILTER( Country, [TotalSales] >= EARLIEST([TotalSales]) ) )

Related DAX Functions

Related Course Modules

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.