Export (0) Print
Expand All

Lag

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


Lag()

A scalar value of the type integer.

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft