EARLIEST Function (DAX)
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]) ) )