Life Cycle Calculation

Hi everyone,

I would like to get the following output in PowerBI. I've read a different post with a solved solution but unfortunately  I can't reproduce the solution without an error. I've asked a question about it in that forum post but unfortunately nobody answers it. Therefore I've opened this new post and I hope someone can help me with a working solution. Old post: Solved: Asset Life Cycle Calculation - Microsoft Power BI Community

I need PowerBI to create the following table. Every AssetNo has to be replaced after it's expected Life for a fixed amount of costs. The next step would be to integrate a index so the replacements cost wil be indexed every year.

The calculated tabled is based on the following dataset. For example every 5 year AssetNo A has to be replaced for a value of € 1.000,--.

I've build the following function that will provide a list of replacement years for each last replacement year. This gives an error.

let
output = List.Generate(
    ()=>[firstValue],
    each _<= [endyear], each _+[life],
    each _
)
in
output

This function creates a list but comes withe an error when I expand the list to new rows.

When I expand to new rows I get the following error. "Expression.Error: We cannot apply field access to the type Number."

When I place a fixed value for endyear (2050) and life (5) then it works fine. I can live wit a fixed value but the value live comes from the dataset.

let
output = List.Generate(
    ()=>[firstValue],
    each _<= 2050, each _+5,
    each _
)
in
output

The output is with tunnecessary columns deleted is:

Does somebody know a solotion for this problem or a different method in PowerBI. Thanks in advance.

Damon

https://1drv.ms/u/s!AvqOdziejqaXluYnp2YAh2Bpk5SYqA?e=oALPaS