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
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
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
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.