Currency Conversion within Power Query Editor

Power Query
1

Hello Everyone,

I would like to convert the amount column from multiple currencies into one single reporting currency (i.e. USD) within the power query editor by way of a calculated column. I know it’s not as efficient as probably doing it with DAX formulae as a measure, but I have my reasons and would like assistance in how to do this. Attached is a power bi dataflow (.json file) with all the sales and currency data.

Retail Sales - test.json (26.6 KB)

Best

Harvey

2

Hi @Harvey,

See if this is helpful.

IMPORTANT Please note that if you don’t have Premium or a Dedicated Workspace Capacity, referencing a query within a Dataflow requires you to disable its load.

I hope this is helpful

1 Like
3

Thank you @Melissa! This is perfect.