Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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 _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.