Forum Discussion
Helper VUsing a Foreign Exchange Table
Hi Centaur
For this case in Power Query, Merge the FX table to tblV1 just on the Currency column. Since you have USD in your FX table as 1, then you can leave out the step replace null values with 1.If this report you are creating is not a one off and you need constant rates, please refer to my post https://community.fabric.microsoft.com/t5/Power-Query/web-content-csv-file-access-forbidden/m-p/3403521/highlight/true#M110756
Thanks
Joe
Hi Joe,
I went ahead and used a sort of lookup. Took awhile but I got it done. I am sure it coudl be done your way too but I wasnt sure how to avoid the duplicates.
VLOOKUP in Power Query Using List Functions • My Online Training Hub
Solution SageHi Centaur
For this case in Power Query, Merge the FX table to tblV1 just on the Currency column. Since you have USD in your FX table as 1, then you can leave out the step replace null values with 1.
If this report you are creating is not a one off and you need constant rates, please refer to my post https://community.fabric.microsoft.com/t5/Power-Query/web-content-csv-file-access-forbidden/m-p/3403521/highlight/true#M110756
Thanks
Joe
Helper VHi Joe,
I went ahead and used a sort of lookup. Took awhile but I got it done. I am sure it coudl be done your way too but I wasnt sure how to avoid the duplicates.
VLOOKUP in Power Query Using List Functions • My Online Training Hub