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. Is this possible to do in Power Query? Any help is much appreciated!

 

Document IDDateTotalCurrrency
400028304/08/20222805DKK
120152704/08/20221258EUR
220152701/08/2022518841USD
117475615/07/202251514NOK
117475920/07/202215145GBP
317476215/07/202254144USD
216996005/07/20225154DKK
417003305/07/20228785EUR
418816615/07/202232595GBP
117698306/07/20225665SEK
117675515/07/20227841DKK
317675915/07/202269792EUR
217678515/07/20229632USD
317681315/07/202255849USD
117681815/07/20221895EUR
117683015/07/202265894NOK
118816615/07/202265612GBP
414497004/07/20225645DKK
400042914/07/202278000SEK
117647815/07/2022319000GBP
400013815/07/2022374000DKK

 

CurrencyConverted to DKK
1 USD7.72
1 EUR7.44
1 GBP8.32
1 NOK0.72
1 SEK0.68

 

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.

     

2 Replies

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    3 years ago

    You would just "Join" (Table.Join or Table.NestedJoin) the two tables, and multiply the columns.

  • 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.