Forum Discussion
Add Live Exchange Rate Month column
Hi Power BI Team , Can some please help me ? I have imported Exchnage rate table from Excel data sheet from 01/01/2017 to 01/06/2019 (GBP TO EUR). can someone guide me how can i add live ex...
Hi Maggie,
thanks for your feed back.
sorry but my question is different. i have Excel table (see below ) up to June-19. but how can it will be automatically updated rates in each cell month by month. i.e in July-19
Kind Regards,
Piyush
Hi PiyushH1
If you add rate data of 2019/7, 2019/8 in your excel file, then click on "refresh" button in power bi, the data model/ report can update to the newest rate data.
If you are not this scenario, which scenario do you have?
Do you want to create new rows of rate data in Power BI with exsiting data?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.