DAX Function Guide

EARLIEST
Empty image or helper icon

Sam McKay

CEO & Founder

How does the EARLIEST 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?

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

Loading

Considerations when using the EARLIEST?

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

Loading

Formula examples using the EARLIEST

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

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

Related Courses

Loading