Hello,

what I’m trying to achieve is getting last year sales (2018) multiply by actual year Budget rate (2019) so I can compare this to Actual year sales at AY budget (2019).

I m using Vlookup to get retrieve the currency and the exchange rate. With this formula:

```
Amounttoconvert = SUMX(Entries, Entries[CC amount] *
LOOKUPVALUE('Currency rates (BG&FORECAST)'[BG'19 Rates],
'Currency rates (BG&FORECAST)'[Currency I have] , Entries[Company currency],
'Currency rates (BG&FORECAST)'[Currency I want] , "CHF",
'Currency rates (BG&FORECAST)'[DateYear] , FORMAT(Entries[Date], "YYYY")
```

This works perfectly since I’m multiplying the each amount by the correct rates given by the Lookupvalue function. But when doing this for LY amount the problem is that I do Calculate( sum( CC amount) , sameperiodelastyear (Dates)) and this formula takes away the “row structure” so the formula would just retrieve nothing.

Any idea?

Thanks

Best regards

Mark Lovejoy