Forum Discussion
Solved
Repeat value from previous line (Language M)
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 colum...
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
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
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"You're right, I didn't understand at first, setting everything to null I can do the filldown later.
Thank you very much.
