Calculating Future Date with last year data dynamically

Alteryxexpert

I have Data like below,

Business	Date	Sales
Bank	12/31/2024	4044
Bank	12/31/2025	4008
Bank	12/31/2026	3906
Bank	12/31/2027	3935
Bank	12/31/2028	5454

I want to Calculate data for 12/31/2029 which should be equal to 2028 dynamically. for example if the workflow is ran next year the 2029 data will be passed to 2030 and next year 2030 data will be equal to 2031 and so on. How can we achieve this in alteryx?

cpet13

@Alteryxexpert it sounds like what you want is to calculate the data for a year, then add 1 year to the date column, which you could do with a formula. Is that what you are looking to do?