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.