Value of the next row

[Anonymous]

Hi,

I want to replace the blank by the value of the next row of the same column. 

In this case I need to have 1409 instead of blank. Thanks

[alexei7 · Accepted solution]

Hi @Anonymous,

You could try creating a new custom column to do this for you.

The formula would be something like:

Column = if(Table1[IDRun4]=0,LOOKUPVALUE(Table1[IDRun4],Table1[Scaling_ID],Table1[Scaling_ID]+1),Table1[IDRun4]) 

(obviously replacing "Table1" with your own table name).

Hope that helps,

Alex

[Anonymous]

Thanks @alexei7 it work!

I should have asked before!!!