LEAD() & LAG() function in Looker Studio

[Lipika_Saini]

Hi,
Do we have Lead() & Lag() functions in the Looker Studio fields?
if not then what are the alternatives which can  be used to serve the same purpose

 

Looking out for Lead() & Lag() functions while creating a field in Looker Studio.

[msrivastava01]

Now we have offset function that can do this.
Refer to https://cloud.google.com/looker/docs/functions-and-operators

[asrishyla]

Offset is an unsupported operator in Looker Studio

[DZlAmir]

any solution for this ?