How get column value from another query based on current query column value?|Power Query|Excel Forum|My Online Training Hub

Hi Francis,

Always best to provide your workbook and data so we don't have to recreate everything from scratch.

If your conversion rate is the output of another query then you can create a custom column and use the rate by referring to the name of the query.  For example;

#"Added Custom" = Table.AddColumn(#"Changed Type", "USD", each [SGD] * USDRate)

takes the values in the column SGD and multiplies them by the output (the exchange rate) of the query USDRate, resulting in a new column called USD.

You can also create a custom function and either hold the exchange rate in that, or read the rate from a cell.

Then by invoking the custom function and multiplying the rate by the SGD, you'll get the same results.

In the attached file I've included examples of both methods.

Regards

Phil