How to collect the previous not blank data to fill down?

[v-kongfanf-msft · Accepted solution]

Hi @bubbledep ,

Modify formula like below:

M_ =
VAR result_ =
    AVERAGEX (
        FILTER ( 'Table', 'Table'[Date] = MAXX ( 'Table', 'Table'[Date] ) ),
        [Value]
    )
RETURN
    IF (
        MAX ( 'Table'[Date] ) = MAXX ( ALL ( 'Table' ), 'Table'[Date] ),
        result_,
        MAX ( 'Table'[Value] )
    )

Best Regards,
Adamk Kong

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