Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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~
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |