FX rate conversion table - missing dates

[Anonymous]

Dear All!

I would like to kindly ask for your help and support regarding the following case.

I downloaded an fx conversion table from the National bank's website. Unfortunately I have sales figures on days where is no fx rate from the NB.

Created a measure which can look back in time and find the last fx rate for missing days. 

When I put this logic into Table format. It is not working.

https://www.dropbox.com/s/tzpk5qfnsoxyw6p/FX%20rate.pbix?dl=0

Here is the link to the pbix file, where you can find all the measures created and table.

Can you please help me?

Thank you

S

[Anonymous]

Great. It is working.

Thank you

S

[HotChilli · Accepted solution]

How about a new table with :

Table 2Exchange table = SUMMARIZECOLUMNS('Date table'[Date],  'FX rates'[Attribute], "FX",[Exchange rate normalised])