I am trying to figure out the difference between LEAD and LAG function; as we can get same value from future and past period by using both function. for Ex: LEAD(x,-2,1000,STRICT) and LAG(x,2,1000,STRICT) will get the result from 2 period before the current cell. Can someone help me where we should use LEAD function .and not LAG function and vice versa Thanks, Ankit
... View more