Currency calculation for last year between two tables
I have the following problem and namely I want for last year the sales in the correctly converted currency eg. Pound to Euro for Great Britain For the current year it works through a calculated column. Does anyone have an idea for this issue?
Total Sales LC = SUM('DataTable'[Total Sales Local Currency])
Total Sales LC LY = CALCULATE(SUM('DataTable'[Total Sales Local Currency]),SAMEPERIODLASTYEAR('DateTable'[Date]))