NEXT
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Used in visual calculations only. Retrieves a value in the next element of an axis in the visual matrix.
Syntax
NEXT ( <column>[, <steps>][, <axis>][, <blanks>][, reset] )
Parameters
Term | Definition |
---|---|
column | The column to be retrieved. |
steps | (Optional) Indicates the number of rows to go forward to fetch the value. If omitted, 1 is used (the exactly next row). |
axis | (Optional) An axis reference. If omitted, the first axis of the Visual Shape definition is used. |
blanks | (Optional) An enumeration that defines how to handle blank values when sorting. The supported values are:
|
reset | (Optional) Specifies how the calculation restarts. Valid values are: None, LowestParent, HighestParent, or an integer. None is the default value. |
Return value
The value of <column> from the next element of the axis.
Remarks
This function can only be used in a visual calculation.
Example
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:
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho