Writing a measure that 'explodes' a 'From' date across subsequent years

[JeffWeir]

Hi all.  I'd like help with a Measure so that I can turn this:

...into this:

...i.e. it will 'expand' that 'Proposed Uplift' data, so that the numbers in the [New Capacity] column get repeated for every year going forward, after the date that capacity first comes on stream.

But no matter what I try, I always end up with this:

I have seen how I can use the DAX @Phil_Seamark  has in his book Beginning DAX with Power BI to create a Table of what I want, as per the below:

...but I want a dynamic measure that I can use directly in a PivotTable  (and later in Power BI) as shown above, not a static Table.

I've tried wrapping a SUMX around the above, but when I use the resulting Measure, I still don't get what I want. And I've tried numerous variations of that, in order to attempt to override the filtering being imposed by the data model.

If I can't do it with DAX, I'll just use PowerQuery to expand the table before feeding it to the data model. But I am sooooo curious as to whether this can be done in DAX.

[v-juanli-msft]

Hi

Best Regards
Maggie

[JeffWeir · Accepted solution]

Yay...   @MattAllington gave me the solution I needed:

=CALCULATE(SUM(Uplift[New Capacity]),FILTER(Uplift,Uplift[Year] <=max(Years[Year])))