Historic Currency Conversion Rates

[mloc1990]

Hi,

I'm building a report that requires a currency conversion. I have set up a measure below that works for converting volumes based on the most recent conversion rate. The table with  the data I'm trying to convert from Euro to US and Canadian Dollars.

and the conversion rates table I'm useing both go back as far as 2016. 

How would I set this is up so if someone selects a date range prior to today it will show that conversion rate for that date?

Selected Currency Volume =

SWITCH(TRUE(),

[Selected Currency XE]="USD", FORMAT([Volume]*VALUES(xe_currency[cur_rate]),"$0,00"),

[Selected Currency XE]="CAD", FORMAT([Volume]*VALUES(xe_currency[cur_rate]),"$0,00"),

FORMAT([Volume],"€0,00"))

Thanks

[v-alq-msft]

Hi, @mloc1990 

Based on your description, you may try creating a measure to get the corresponding conversion rate of the current data range. Then you can use call the new measure in your formula. 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.