Forum Discussion
FX rate conversion table - missing dates
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
How about a new table with :
Table 2Exchange table = SUMMARIZECOLUMNS('Date table'[Date], 'FX rates'[Attribute], "FX",[Exchange rate normalised])
2 Replies
How about a new table with :
Table 2Exchange table = SUMMARIZECOLUMNS('Date table'[Date], 'FX rates'[Attribute], "FX",[Exchange rate normalised])