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)