Replace Null Value with Last Known Value

[Former Member]

I have a table where I have null values that I wish to replace with the previous value. i.e. As per the screenshot, the left hand table is the original table....and the RH table is the desired end result. Numbers in red are those that I wish to 'add'

I have tried

if (isnull([X])) then previous[X]) else [X] but this doesnt work..... any ideas?

BI 4.1 Webi SP4

[sateesh_kumar1 · Accepted solution]

Hi Joe ,

Try

=If(IsNull([X]);Previous(Self);[X])

[Former Member · Accepted solution]

Oh that worked perfectly! Thanks so much