Repeat value from previous line (Language M)

[Frnztt]

Good afternoon everyone, I need help bringing information from my previous line, I will describe here what I am doing.

Based on the table below:

From this table I need to add another column named "Recurso" where I must put the name that comes before the dates.

Use the formula below to find the name:

= Table.AddColumn(#"Inserção de Coluna Index", "Recurso", each
let
CurrentData = [Data],
PreviousData = if [Index] > 0 then {[Index]-1}[Recurso] else null
in
if Text.Contains(CurrentData, "/") then PreviousData else CurrentData
)

What I'm not able to solve is copying the information from the previous line "Recurso" and rewriting it in the "Recurso" column when my column is a date, below is the image of the result obtained:

[HotChilli · Accepted solution]

Do you mean you want to get the name for each section on the same row as the date?

--

I think the code provided can be simplified:

if Text.Contains([Data], "/") then null else [Data])

then do a Fill.Down on the column

[Frnztt]

You're right, I didn't understand at first, setting everything to null I can do the filldown later.
Thank you very much.

[Frnztt]

What I need is that when it doesn't identify the "/" of the date, it retrieves the information from the previous line that I'm filling in.
Example, if you don't find "/" take the name information and write it in "Recurso", if you don't find "/" return the name placed on the previous line of "Recurso"