Hi @Chittaranjan - welcome to the QuickSight Community! Thanks for asking your question.
Can you please try the lag function?
Here is another post that’s similar to your ask: How to create calculate field to fetch previous value in column?
Please let us know if this addresses your need.