Date Value Expected Column
2023-01-01 25 25
2023-02-01 30 25
2023-03-01 32 25
2023-04-01 22 22
Question
Dear community, Trying to look for min value before the current date. Can someone suggest the possible query to get the below desired column?
+26
I think the 'MOVING_MIN' function is exactly what you need: https://docs.celonis.com/en/moving_min.html.
Best regards,
Jan-peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.