Can EARLIER be used in DAX measures?

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive

EARLIER is a DAX function that acts exclusively on row context, and its purpose is to create a reference to a column value on an outer loop of the evaluation of the expression. It is commonly used in calculated columns during nested row by row iterations.

One of the things that I have been wondering for about a year now (an eternity in this digital era!) is if it would be possible to use it in a measure. An example would perhaps make this more clear: suppose you want to use EARLIER to calculate running total values on a table like this one:


Tags: dax, design


2007-2015 VidasSoft Systems Inc.