Currency calculation for last year between two tables

[ys034]

Hello Community,

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?

My Measures:

Total Sales LC = SUM('DataTable'[Total Sales Local Currency])

Total Sales LC LY = CALCULATE(SUM('DataTable'[Total Sales Local Currency]),SAMEPERIODLASTYEAR('DateTable'[Date]))

Calculated Column: 

Total Sales EUR = [Total Sales LC] / RELATED('Currency Table'[Exchange Rate])

Total Sales EUR LY = [Total Sales LC LY] / RELATED('Currency Table'[Exchange Rate]) (info: a circular dependency was detected)

My Model:

thank you in advance

[amitchandak · Accepted solution]

@ys034 , You should not create a column on measure. You should now create a measure only

something like

Total Sales LC Curr = SUMX('DataTable', 'DataTable'[Total Sales Local Currency]/ RELATED('Currency Table'[Exchange Rate]))

Total Sales LC Curr LY = CALCULATE(SUMX('DataTable', 'DataTable'[Total Sales Local Currency]/ RELATED('Currency Table'[Exchange Rate])),SAMEPERIODLASTYEAR('DateTable'[Date]))