Live currency converter excel how to#
Live currency converter excel free#

Make sure that the dataflow is scheduled to refresh regularly (the data of the API is getting refreshed every hour).

Live currency converter excel free#

The method used in these two parts gets the data from a free currency exchange rate API, and I highly recommend to use dataflow or any intermediate storage so that you can minimize the number of API calls through this process. This is a column that you can use in your reports now. You can call this new column as a Converted rate or whatever else you like. The final step is to multiply the SalesAmount in each row by the Rate, You can do that with pressing and holding the Ctrl key, selecting the two columns, and then from the Add Column tab, under the Standard menu, select Multiply. You cannot remove this table, but you can disable the load of this table ĭisable load makes sure that no unnecessary tables are loaded into Power BI. The Currency Conversion Rate Table server no purpose any longer, the result of that is now added in your transaction table as the Rate column. Now you should have rates for each row in that column You can expand it, and all you need from that table is the Rate column (Make sure this column is a decimal or fixed decimal data type) This should give you a new column in the transaction table which is the exchange rate table. To merge based on multiple columns, hold the Ctrl key and select column in the order that you want (similar order in both tables) Merge Tablesīecause the data from the Conversion Rate Table is now loaded as a table, you can easily merge the transaction table to this table using the Current Currency and To Currency columns The SalesAmount is in the Currency Currency and has to be changed to the To Currency. Here is an example of some rows in this table Īs you can see the table has two columns for Current Currency and the currency that we want the amount to change. I have a sample transaction table that all rates are in NZD and AUD, and I want to change them all to USD. Select Transform Data to get to the Power Query Editor Window. Start with getting data from the Currency conversion table using get data from Dataflow

Live currency converter excel how to#

If you haven’t got this table yet, read the first part of this article here to learn how to create such a table. In this blog post, I’ll be using the Conversion Rate Table that has all required currencies and their live rates fetched from API.

In this part, I will show you how you can use the currency conversion table that we generated in dataflow to convert millions or billions or rates in Power BI. In that part, you learned how you can create a table in dataflow using live rates. In the previous part of the currency exchange rate conversion, I provided a function script that you can use to get live rates using a free API.