LEAD() & LAG() function in Looker Studio

Looker Q&A Looker
, ,
1

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

2

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

3

Offset is an unsupported operator in Looker Studio

4

any solution for this ?