We integrate a currency conversion in Power BI and have used Euro Stat for this. This works so far that we have all currency conversions for working days. Currently it looks like this:
We would like to have a table where weekends and Public Holidays are included.
The idea was to take previous values. Whenever a value is missing, a previous value would have to be taken (idea was a loop, go back until value is filled in and then take this value).
For this, we need to add a complete date list + attribute (currency indicator). For example we need two rows for saturday(one for USD and one for CNY).
We have a full calendar in our PBI file that could be used for joints or whatever the idea is.
Thanks in advantage