Currency calculation for last year between two tables

ys034 — Fri, 21 Jan 2022 14:08:26 GMT

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

Re: Currency calculation for last year between two tables

amitchandak — Fri, 21 Jan 2022 14:23:01 GMT

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]))

topic Re: Currency calculation for last year between two tables in DAX Commands and Tips

Currency calculation for last year between two tables

Re: Currency calculation for last year between two tables