Skip to Content
Former Member
Mar 12, 2015 at 11:46 PM

Replace Null Value with Last Known Value


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


Capture.PNG (4.8 kB)