Forum Discussion
Power Query to combine tables and create a custom field
Using Power Query or the underlying "M" language:
How could I combine multiple tables based on the common index column "country" to produce a currency conversion as shown in the images below:
Local Currency Transactions * FX Rates = Currency Adjusted
Cross posted on SO:
1 Reply
- austinsense
Impactful Individual
Alright you're gonna be happy with how easy this is.
You want yo "Merge" the queries together based on the country column. When you merge them you'll have all of the columns on one table and then you can do the math to convert to USD.
