Differnce between LEAD and LAG function

Ankit_Negi

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

Ankit_Negi

Kindly ignore STRICT mode and treat it as NONSTRICT