GBP to EUR exchange rate for every date.

[MikaelB]

I'm new(ish) to PowerBI.
I could not find answer or guide to this.

Problem:

Need to generate table with EUR to GBP exchange rate for every day from 01.01.2015 to current date.

This needs to be updated daily, or whenever dashboard refresh.
I know how to get current and some historical date currency rates with Web source from different sites. But how do i generate those rates for every date?

I have gone through countless amount of tips but with no success.
Is there step by step guide for this? What would be best site to use as web source?

Thank you.

[amitchandak · Accepted solution]

@MikaelB , refer, if these can help

https://community.powerbi.com/t5/Service/Historical-exchange-rate-API/td-p/742021

https://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2

[MikaelB]

Good sir.

Your first link gave answer to problem.
Only problem still existing is to change this line to be. From certain date (01.01.2015) to current date. So that the starting date never changess

{Number.From(Date.AddDays(DateTime.Date(DateTime.LocalNow()),-365))..Number.From(DateTime.Date(DateTime.LocalNow()))}

Thank you 🙂