EARLIER DAX Function Not recommended
Returns the value in the column prior to the specified number of table scans (default is 1).
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| ColumnName |
The column that contains the desired value. |
|
| Number | Optional |
The number of table scan. |
Return values
The current value of row, from ColumnName, at Number of outer evaluation passes.
Remarks
EARLIER succeeds if there is a row context prior to the beginning of the table scan. Otherwise it returns an error.
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.
» 1 related function
Examples
-- EARLIER evaluates a column in the outer row context, in case there
-- are multiple row contexts open in the same expression
--
-- EARLIER accepts a second argument that represents the number of steps
-- EARLIEST retrieves the first ever row context
EVALUATE
ADDCOLUMNS (
VALUES ( Customer[Yearly Income] ),
"Customers", CALCULATE ( COUNTROWS ( Customer ) ),
"RT Customers",
COUNTROWS (
FILTER (
Customer,
Customer[Yearly Income] <= EARLIER ( Customer[Yearly Income] )
)
)
)
ORDER BY [Yearly Income]
| Yearly Income | Customers | RT Customers |
|---|---|---|
| 10,000 | 1,155 | 1,155 |
| 20,000 | 1,767 | 2,922 |
| 30,000 | 2,287 | 5,209 |
| 40,000 | 2,747 | 7,956 |
| 50,000 | 670 | 8,626 |
| 60,000 | 3,127 | 11,753 |
| 70,000 | 2,349 | 14,102 |
| 80,000 | 1,342 | 15,444 |
| 90,000 | 842 | 16,286 |
| 100,000 | 571 | 16,857 |
| 110,000 | 474 | 17,331 |
| 120,000 | 332 | 17,663 |
| 130,000 | 512 | 18,175 |
| 150,000 | 103 | 18,278 |
| 160,000 | 94 | 18,372 |
| 170,000 | 112 | 18,484 |
| 10,000,000 | 385 | 18,869 |
-- EARLIER is superseeded by a careful usage of variables.
-- It is a best practice to avoid using EARLIER to make the code easier
-- to author and maintain.
EVALUATE
ADDCOLUMNS (
VALUES ( Customer[Yearly Income] ),
"Customers", CALCULATE ( COUNTROWS ( Customer ) ),
"RT Customers",
VAR CurrentYearlyIncome = Customer[Yearly Income]
RETURN
COUNTROWS (
FILTER (
Customer,
Customer[Yearly Income] <= CurrentYearlyIncome
)
)
)
ORDER BY [Yearly Income]
| Yearly Income | Customers | RT Customers |
|---|---|---|
| 10,000 | 1,155 | 1,155 |
| 20,000 | 1,767 | 2,922 |
| 30,000 | 2,287 | 5,209 |
| 40,000 | 2,747 | 7,956 |
| 50,000 | 670 | 8,626 |
| 60,000 | 3,127 | 11,753 |
| 70,000 | 2,349 | 14,102 |
| 80,000 | 1,342 | 15,444 |
| 90,000 | 842 | 16,286 |
| 100,000 | 571 | 16,857 |
| 110,000 | 474 | 17,331 |
| 120,000 | 332 | 17,663 |
| 130,000 | 512 | 18,175 |
| 150,000 | 103 | 18,278 |
| 160,000 | 94 | 18,372 |
| 170,000 | 112 | 18,484 |
| 10,000,000 | 385 | 18,869 |
Related articles
Learn more about EARLIER in the following articles:
-
Variables in DAX
In this article, you learn a new feature in DAX 2015: variables. The 2015 version of the DAX language has many new functions, but none of them is a game changer for the language as variables are. » Read more
-
DAX coding style using variables
This article shows how variables in DAX can impact the coding style, simplifying a step-by-step approach and improving the readability of your code. » Read more
Related functions
Other related functions are:
Last update: Jan 31, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/earlier-function-dax