NEXT - Daxplained

NEXT is a DAX function that retrieves a value from the next row of an axis in a visual calculation data grid.

Syntax

NEXT(
   Expression,
   Steps,
   Axis,
   Blanks,
   Reset
)

Argument	Properties	Description
Expression		The expression to be evaluated.
Steps	Optional	Step is the offset value. The value should be greater than or equal to 1. Default is 1.
Axis	Optional	An axis reference.
Blanks	Optional	Defines how to handle BLANK OrderBy values. Valid values include: DEFAULT, FIRST, LAST.
Reset	Optional	Specifies how the calculation restarts. Valid values are: None, LowestParent, HighestParent, or an integer.

The value of column from the next element of the axis.

This function can only be used in a visual calculation.

The following visual calculation returns the sales amount of the next row on ROWS axis, that resets on the lowest parent.

NextInternetSalesAmount = NEXT ( [Sum of SalesAmount], ROWS, LowestParent )

The screenshot below shows the visual matrix and the visual calculation expression:

DAX visual calculation

Contribute » | Contributors: Rick de Groot