How To Download Latest Exchange Rates Into Your Power BI Model



In this tutorial I detail how by querying the web you can download the latest exchange rates in your Power BI reports. This may be important for financial analysis …

source

How To Download Latest Exchange Rates Into Your Power BI Model

In this tutorial, I detail how by querying the web you can download the latest exchange rates in your Power BI reports.

This may be important for financial analysis or any cross border reporting.

Good luck with this one.

Chrs
Sam

*****Video Details*****
0:41 - Querying The Web
2:25 - Filtering The Currencies
3:22 - Making Changes and Updating The Currencies
4:14 - Utilizing The Downloaded Currency Rates
4:58 - Conclusion

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
Multiple Currency Logic In Power BI – LOOKUPVALUE Example
https://blog.enterprisedna.co/2017/12/14/multiple-currency-logic-in-power-bi-lookupvalue-example/
Update to Multiple Currencies Management in Power BI - Advanced DAX
https://blog.enterprisedna.co/2018/02/02/update-to-multiple-currencies-management-in-power-bi-advanced-dax/
How To Deal With Products That Have Changing Prices Overtime In Power BI
https://blog.enterprisedna.co/2019/07/17/how-to-deal-with-products-that-have-changing-prices-overtime-in-power-bi/

***** Related Course Modules *****
Unique Analytical Scenarios
http://portal.enterprisedna.co/p/unique-analytical-scenarios
Advanced Data Transformations & Modeling
http://portal.enterprisedna.co/p/advanced-data-transformation-and-modeling
Best Practices & Feature Reviews
http://portal.enterprisedna.co/p/best-practices-feature-reviews

***** Related Support Forums *****
Calculate Currency Exchange Impact Between 2 Years
https://forum.enterprisedna.co/t/calculate-currency-exchange-impact-between-2-years/1506
Converting Currency
https://forum.enterprisedna.co/t/converting-currency/1912
Translating INR Amount To USD Based On User Slicer Selection
https://forum.enterprisedna.co/t/translating-inr-amount-to-usd-based-on-user-slicer-selection/2013
For more exchange rate queries to review see here…..
https://forum.enterprisedna.co/search?q=exchange%20rates