Lag (DMX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the time slice between the date of the current case and the last date of the training set.

Syntax


Lag()  

Return Type

A scalar value of the type integer.

Remarks

If the Lag function is used on a model where the KEY TIME column is located within a nested table, the function must be located within the sub-select of the statement.

Examples

The following example returns cases that fall within the last 12 months of the data that was used to train the model.

SELECT * FROM [Forecasting].CASES  
WHERE Lag() < 12  

See Also

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
General Prediction Functions (DMX)