forecasting scenarios based on initial numbers

I need to create a forecast based on a set of initial numbers that will be pulled auotmatically from a data source.

this is what my initial data looks like

is then want to be able to apply a formula to total producs and green product to create a forecast based on some input criteria, text in green would be the forecasted values

The formula for the forcast are as follows

Total Products = previous year Total Product * growth factor

Green Products = previous year Green products - previous year Green product * green products discontinued factor + sum(Total Products - (total products/(1+growth factor)), previous month Green product *  green products discontinued factor), (total products - previous year green products)* other product discontinued factor) * new green products factor

Growth factor is a percentage that needs to be adjustable between 1 and 10%

Green products discontinued factor is a percentage that needs to be adjusted between 1 and 10 %

Other products discontinued factor is a percentage that needs to be adjusted between 1 and 10 %

New Green products added factor is a percentage that needs to be adjusted between 10 and 50 %

Currently using parameters for the above.

figured out how to generate a list for the months including the initial value by using something like the below

let
    StartYear = 2023,
    EndYear = 2035,

    YearList = List.Generate(
        () => StartYear,
        each _ <= EndYear,
        each _ + 1
    ),

    CustomList = List.Generate(
        () => [Year = StartYear, Value = 1000],
        each [Year] <= EndYear,
        each [Year = [Year] + 1, Value = [Value] * 1.01],
        each [Value]
    ),

    NewList = List.Generate(
        () => [Year = StartYear, Value = 200],
        each [Year] <= EndYear,
        each [Year = [Year] + 1, Value = [Value] + ([Value] * 0.07)],
        each [Value]
    ),

    Result = Table.FromColumns({YearList, CustomList, NewList}, {"Year", "Total Products", "Green Products"}),

Challanges are:

- inputs are not dynamic

- can't figure out the formula

Tried creating a manual data table with the years and initial data then use a measure like below to forecast the Products increase

Total Producst Forecast = 
var a = calculate (LASTNONBLANKVALUE('Table'[Total Products],calculate(sum('Table'[Total Products]))), all ('Table'))
return 
a * (1 + 'Growth Factor'[Growth Factor Value])

 However that only works for the first row, subsequent rows have the same data

I know i can use something like 

Previous row value = var a=CALCULATE(SUM(Table1[Index]))-1
return CALCULATE(MAX('Table1'[Value]),FILTER(ALL('Table1'),'Table1'[Index]=a))

to get the previous row in a new column which could be helpfull with some of the calculations.

I think i got some of the pieces of the puzzle together but I think i'm still missing something.