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?
Can you use lag / lead , partition by your partition, and offset it?
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