For key figure Stock end, there is one value for current week (W02 2023)-27 which is dynamic and value can be change on daily basis.

When we will come at next week, the value for key figure will get displayed in (W03 2023) and no value (blank) in (W02 2023).
Requirement: User want to see in future what was the value of that key figure in (W02 2023), when we will move on to the next weeks further.
For example: We are in (W07 2023) now, then user want to see the value in (W02 2023 or W03 2023....) which is currently blank.
So I want to copy the data for key figure value of current week (W02 2023) before the start of the next week when value will get shifted automatically to (W03 2023).
When I will be in W03 2023, I want to see what was the value at the end of (W02 2023).
(We cannot use snapshot because it has limitation of 9 only and user wish to see the data in the past time bucket from current week onwards)
(Note: This is the KF from order based planning area and the data for this key figure described above is updated by the CI-DS job running on daily basis)