Forum Discussion
Custom column for currency conversion
Hello, I have the following two tables loaded in Power Query and i am trying to add a new column to the first table for "Converted to DKK" based on the currency exchange rates in the second table. I...
Hi Anonymous ,
According to your description, here's my solution.
Select the first table, then click Home>Merge Queries.
Select Currency column in the two tables and select the option "Use fuzzy matching to perform the merge", as in your sample, the currency columns in two tables are not totally the same.
Then expand the Converted to DDK column, get the result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You would just "Join" (Table.Join or Table.NestedJoin) the two tables, and multiply the columns.