Home

evaluating value in previous record of same field

Highlighted
brett.spector null
Occasional Contributor

I have a query - and I am happy to implement this in the data model as that is where it is loaded to - so either in a custom column in the query tool or a column added in the data model, I don't care either way - but it need to be in load to data model only because it is more than 1 million rows.  If the record set was within the tab limit of excel I could easily implement this in the tab itself and then just make a query from the table.  

 

So, assume 2 columns - 1 is from the data source one is my new column

 

 

Datasource      NewColumn

null                     NewColumn

null                     NewColumn

1034                  1034

null                    1034

null                     1034

2234                    2234

null                      2234

null                      2234

 

So essentially I want to write a formula in NewColumn that says if DataSource is null then take the preceding record value of NewColumn otherwise take DataSource.

 

Anyone please help - even Bueller!

 

 

1 Reply

You can do it in-place using  fill -> down (under any column) or duplicate the column and then use fill -> down 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies