PowerPivot DAX Session Notes 2 - Previous Row
User Rating: 5 / 5
Those that are familiar with PowerPivot and DAX, will be aware that DAX provides the ability to reference columns. However, it does not provide support for Cell based references (such as A1, E23).
This is normally no big issue, until I hit a small design issue this week... I had the requirement to refer to a previous row of data within the PowerPivot model. And yes, it is possible, using the EARLIER DAX function.