I want to fill in the blank with the latest value

[Eiji77]

I want to fill in the blank with the latest value.

Please help me.

I am a Japanese who can not speak English.

[Anonymous]

Hi, 

What formula are you using for Exchange Value?

Ioana

[Eiji77]

Hi. Thank you. Exchange Value is tihs table.

[Anonymous]

if the column is in your source data then in Edit Queries, sort the data after Exchange Date and go to Transform tab, use Fill option, with fill Down.

[Eiji77]

Thank you for answering. Sorry, the Exchange table has no Exchange date if there is no Exchange value. The image is as follows. Therefore, I can not fill in the query. I want to enter the latest Exchange value for dates in the calendar table although there is no Exchange date.

[Eiji77 · Accepted solution]

Self-solved by adding a query.