currency conversion using exchange rate table from single to multiple currency

[Anonymous]

 value tableI need to use exchange rate table to my value table from which all my graphs are made.

when we switch location value table a currency in Local Currency I need to filter multiple currencies from and between multiple rate Average Rate (AR) and Closing Rate (CR)

I anyone has worked on similar data model in the past Please suggest/ share any model/measures.

Thank you in Advance

both tables map with year month and loaction columns

[v-alq-msft]

Hi, @Anonymous 

I'd like to suggest you use LOOKUPVALUE Function (DAX). You may also go to 'Query Editor' and merge queries as your requirements.

Here are some similar threads you may refer.

Currency conversion 

Help with currency conversion 

Best Regards

Allan

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

[Anonymous]

here is the exchange rate table