Fill empty rows with previous non null values not working

[John_SM]

Hello, I know that there are a lot of topics on how to fill empty rows with peek but in my case it doesn't seem to work as it fills out only one value and not until another value is available

I have used this:

FinalChurnRate:
LOAD *,
IF(Len(Trim(FinalChurnRate)) = 0, Peek(FinalChurnRate), FinalChurnRate) AS FinalChurnRateComplete
Resident ChurnRate;

I have tried with peek('FinalChurnRate') or peek(FinalChurnRate,-1), but nothing is working

[maxgro · Accepted solution]

maybe

LOAD
IF(LEN(TRIM(FinalChurnRate))=0, PEEK('FieldNew'), FinalChurnRate) as FieldNew
Resident ChurnRate;

[John_SM]

Thank you very much, its working now :).

Is it also possible to fill empty rows with the median of the last 3 months?
I tried with rangefractile but again with no success.

In this example I would need to do the median of the last 3 months (Nov, Dec, Jan) and populate the empty rows with that value