Dear community,
I've already posted a question about this, but I didn't get any solution, so I've tried a new approach now by creating a date table which solves the needed insert issue within my original dataset. As you can see in the attached testfile, I've got a table with exchange rates, but unfortunately for some dates, there is no rate known. Is it possible to create a new table through a calculated field in which those blanks are filled in? Whenever the field exchange rate is blank it needs to be filled in with the first possible previous value. As you can see, for the 26th and 27th of August both exchange rates are blank so simply using a calculation with -1 isn't an option. It really needs to search for the first previous value available. I really appreciate any help! Thank you!
With kind regards,
Diana
Hi @Diana Luijben , try the suggestion below.
IF ISNULL(LOOKUP(SUM([Exchange rate (Exchange rate)]),0)) THEN PREVIOUS_VALUE(SUM([Exchange rate (Exchange rate)]))
ELSE SUM([Exchange rate (Exchange rate)]) END
workbook is attached for ref. I hope this helps.
