Fill in missing values in a Matrix

Hi Anonymous ,

first we need create a table:

Table = GENERATESERIES(MIN('lead time history'[Year]),MAX('lead time history'[Year]),1)

then create a measure:

Measure = 
VAR CurrentItem = MAX('lead time history'[Item No])
VAR CurrentYear = MAX('Table'[Year])
RETURN
    CALCULATE(
        MAX('lead time history'[Clean New Lead Time]),
        FILTER(
            ALL('lead time history'),
            'lead time history'[Item No] = CurrentItem
            && 'lead time history'[Year] <= CurrentYear
        )
    )

model:

result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum