Revenue in Different Currencies

I have uploaded a Power BI file with sample data at this link: https://github.com/akimno/power-bi.

1. Converting revenue to euros:

   • The revenue is recorded in different currencies.
   • The user selects a month and a year using the filter (
     'Rate'[monthYear]).
   • Once the month and year are selected, I retrieve the exchange rate(
     'Rate'[Rate])
     for that period.
   • I divide the revenue amount in the local currency by the exchange rate to obtain the revenue in euros ('Revenue'[Revenue Euro N]).

2. Comparison with the previous year:

   • I want to calculate the revenue in euros for the previous year in the same way ('Revenue'[Revenue Euro N-1]).
   • Then, I want to display the comparison between the two (for example, as a difference).

The problem: I’m unable to correctly display the value of the previous year’s revenue.