OFFSET v LAG v LEAD

Hi All,

I understand each of these functions but could someone succinctly explain the difference. 

I would naturally lean towards using OFFSET when looking to pull and push data from different time periods so I have never actually used LAG or LEAD in a live build.

Where would LAG or LEAD be used over OFFSET?

Best Answers

Answers