Multi-Row Formula Tool with random null value

[Istwineres]

Hi all, I'm looking for a solution for this situation: a column where the correct value is present but in a totally random position like this example

Date                or it could be      Date  

Null                                            Null

Null                                            Q4 2020

Q4 2020                                     Null

Null                                            Null

Null                                            Q4 2020

Null

Null

Q4 2020

The desired output should be:

Date

Q4 2020

Q4 2020

Q4 2020

Q4 2020

Q4 2020

If I use iif(isnull([Date]),[Row-1:Date],[Date]) it works except for first record that remains blank

[mceleavey]

Hi @Istwineres ,

I've attached a tool that autofills the value down for you.

Hope this helps,

M.

[atcodedog05]

Hi @Istwineres 

Is the value same for all rows or do they change. If yes can you provide more example.

[Drussek · Accepted solution]

If there is always only one distinct value per column, you may use this flow:

[Istwineres]

Same value for all records

[atcodedog05 · Accepted solution]

Hi @Istwineres 

This can be easily done by filtering non null quarter groupby to get a single value. Then add it back a column to main data.

Edit : Similar to @Drussek approach.

Hope this helps 🙂