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
Solved! Go to Solution.
Hi @Istwineres
Is the value same for all rows or do they change. If yes can you provide more example.
If there is always only one distinct value per column, you may use this flow:
Same value for all records
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 🙂