Forum Discussion
Currency Conversation
I have a fact table which has Invoice amount,currency( having mutiple currencies),invoice number also have another table currency conversion which has Starting currency, distination currency, exchange date,exchange rate. I need to calcuate the invoice amount in to single currency.What is the best approach to make a join between fact table and currency conversation tables.
Hi Anonymous ,
was your problem solved?
6 Replies
Anonymous , You can get the currency rate in the transaction table and convert it, if it is needed only for one currency.
Getting data from one table to another example - you will have more joins
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])
in case you need it dynamic in UI
refer
https://www.youtube.com/watch?v=4dosxfNxR6M
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
https://radacad.com/currency-converter-power-bi-function-part-1
https://www.youtube.com/watch?v=Q4hF4CwJsFEhttps://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2
https://businessintelligist.com/2015/03/17/power-bi-tutorial-how-to-implement-currency-conversion-using-power-query-and-power-pivot/
https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-biHi Anonymous ,
CAn you explain your query using some screenshots from sample data and Power BI?
This is not helping much here.
Thanks,
Pragati
Hi Anonymous ,
You can have a look at these Videos.
https://www.youtube.com/watch?v=Q4hF4CwJsFE
https://www.youtube.com/watch?v=_ubNovnNx5k
https://www.youtube.com/watch?v=4dosxfNxR6M
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!
Hi Anonymous ,
was your problem solved?
