Constant currency analysis is very popular when we need to take out FX rate fluctuations from our analysis. There are many different methodologies that companies used for determining what constant FX rate to apply to the historical values. In our tutorial, we will take a look at the time window for our analysis, figure out what the latest exchange rate was for each currency and then restate the entire history using this rate. In other words, if the exchange rate was always the same as what it was on the last day of our time window, what would the trend look like?

Link to blog and the Power BI model used in this tutorial: [ Ссылка ]

свернуть