QuickSight Equivalent to the Tableau LOOKUP function

Good morning,
Tableau has a function called LOOKUP. I have included a screenshot of what it does. I saw that QuickSight does not have the LOOKUP function in the calculated field. Do you know whether QuickSight has an equivalent of this function?
Thank you,

Can you use lag / lead , partition by your partition, and offset it?

1 Like

Good afternoon Max,
Thank you so much for your response. I will look into how to use the Lag function with the dataset.

Have a great day