Problem with filling empty spaces in column

Hi RicPT ,

Based on my testing again, please try the following DAX formula:

1.Create the new column and enter the following DAX formula.

filledcolumn = 
var index_ = 'Table'[Index]
RETURN
CALCULATE(
    LASTNONBLANK('Table'[Value], TRUE()),
    FILTER(
        ALL('Table'),
        'Table'[index] <= index_
    )
)

2.Drag the column into the table visual. The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.