EARLIEST

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

Syntax

EARLIEST(<column>)  

Parameters

Term Definition
column A reference to a column.

Return value

A column with filters removed.

Remarks

  • The EARLIEST function is similar to EARLIER, but lets you specify one additional level of recursion.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

The current sample data does not support this scenario.

= EARLIEST(<column>)  

EARLIER function
Filter functions