Currency conversion with currency and year filters
I have 4 tables downloaded from the bank regarding exchange rates (CurrencyRates_2020,CurrencyRates_2021, etc.) in which there are columns with currencies, months and exchange rates, in the finance table there are columns amounts, inflows, outflows, date. I also added a table that contains currency column that I used to create the filter.
What I would like to do is create a measure for amounts, outflows and inflows that will convert to the currency selected by the filter in the year selected by the filter. I've only written the part for the selected currency
, but I don't know how to add a date filter. I would like it to fetch me data from the file "CurrencyRates_2021" when I select the date 2021 etc.
As long as you set a scheduled refresh in the Power BI service then they will update. You could also choose not to reload the older versions, which won't change, by right clicking on the query in Power Query editor and unticking "include in report refresh".