FOR Next

By default, the FOR Next function refers to values from one time period in the future. This can be customized by adding a second parameter to the function.

Syntax

SELECT … FOR Next(…,…)
SELECT metric FOR Next(time_attribute)

Examples

SELECT Revenue FOR Next(Quarter)

By default, FOR Next()refers to values from one time period in the future. This can be customized by adding a second parameter to the function. For example, you might want to return a payment value from three quarters in the future with respect to a certain time period (see below).

SELECT Payment FOR Next(Quarter,3)