Dividing the value by currency

[ANM_97]

Hello!

I have the following problem:

PRICE	CURRENCY
500	EUR
200	USD

And these are the values ​​of the currencies in the daily record table:

DATA	CURRENCY_CODE	VALUE
29.05.2020	EUR	4.8426
29.05.2020	USD	4.3517

How can I build a measure that divides the price by the value of the currency?

The results should be:

PRICE	CURRENCY	PRICE IN RON
500	EUR	103.25
200	USD	45.96

Thank you~

[amitchandak · Accepted solution]

@ANM_97 , refer if this can help

https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/

https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-bi

https://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2