lastvalue
1 Topic
Carry over last values for future dates
Hello, I have a data set that looks like below. Looking to carry over the last values from each region for all the Current/Future date values DATE REGION MONTH VALUE EXPECTED VALUE 1/1/2024 A PAST 1 1 1/1/2024 B PAST 2 2 2/1/2024 A PAST 3 3 2/1/2024 B PAST 4 4 3/1/2024 A CURRENT/FUTURE 3 3/1/2024 B CURRENT/FUTURE 4 4/1/2024 A CURRENT/FUTURE 3 4/1/2024 B CURRENT/FUTURE 4 5/1/2024 A CURRENT/FUTURE 3 5/1/2024 B CURRENT/FUTURE 4Solved630Views0likes2Comments