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