Differnce between LEAD and LAG function

Options
Ankit_Negi
Ankit_Negi Member, ALL USERS, Partner, Certified Model Builder Posts: 3 New Contributor
in Planning & Modeling

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

Tagged:

Comments

  • Ankit_Negi
    Ankit_Negi Member, ALL USERS, Partner, Certified Model Builder Posts: 3 New Contributor
    Kindly ignore STRICT mode and treat it as NONSTRICT

Categories