| title | Lag (DMX) | Microsoft Docs |
|---|---|
| ms.date | 06/07/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | dmx |
| ms.topic | conceptual |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
[!INCLUDEssas-appliesto-sqlas]
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
Data Mining Extensions (DMX) Function Reference
Functions (DMX)
General Prediction Functions (DMX)