How to set the null value to the previous value

hooleee 

measure = 

VAR current_date =
    MAX ( dimdate[date] )

VAR ds =
    SELECTCOLUMNS (
        CALCULATETABLE (
            LASTNONBLANK (
                VALUES ( dimdate[date] ),
                [ measure]
            ),
            REMOVEFILTERS ( dimdate ),
            dimdate[date] <= current_date
        ),
        dimdate[date]
    )

VAR res =
    CALCULATE (
        [measure],
        dimdate[date] = ds
    )

return

res

let me know if it works for you ,

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠