Forum Discussion

nikhil0511's avatar
nikhil0511
Icon for Advocate I rankAdvocate I
5 years ago

Getting 52 week high and Low Currency exchange rate

Hello,   I have data with Products and their Prices in USD. I like to convert the prices into EUR. As the prices can be dynamic, I like to calculate average of 52 week -high and low rates, and aga...
Need Help
nikhil0511's avatar
nikhil0511
Icon for Advocate I rankAdvocate I
5 years ago

Hello again,

I would like to write and get the same table into the excel file, 

 

I tried to insert the code you have provided on in my excel power query, but it shows an error stating module missing.

 

Can you help me by rewriting the same code suitable for the Excel power query?