Using latest value

[sw123]

Hi,

I have a exchange rate table, that looks like this:

Start date

Base currency

Currency

Exchange rate

The Exchange rate is put into this table manually, and this doesn´t happen every day, so there will be date gaps in the table. Is there a way for me to fill in the date gaps, with the latest values? That means, that of there aren´t any values for 13.2., it would fill in the same value as we had for 12.2. 

Thankful for help!

[ryan_mayu]

could you pls proivde some smaple data and expected output?

[bhanu_gautam]

@sw123 

First, create a date table that includes all the dates in the range you are interested in.

Merge your exchange rate table with the date table to ensure that all dates are included.

Use the "Fill Down" feature to propagate the last known exchange rate to the missing date