Compare CY vs same period selected year

[tsynenkyy]

Hi,

Currenly Im available just to make a comparison between CY and PY:

Spend Selection CY = [Spend Amount Original]

Spend Selection PY = CALCULATE([Spend Amount Original],PARALLELPERIOD(DIM_TIME[Date],-12,MONTH))

This works great, but the new requierement is selecting the both years I want to compare.

[johnt75 · Accepted solution]

I would set up 2 new tables for use on the slicers, 

First Year = ALLNOBLANKROW('Date'[Year])

Second Year = ALLNOBLANKROW('Date'[Year])

Do not connect these tables to anything in the model. The create 2 measures as

Value for first year = CALCULATE( [Spend Amount Original], TREATAS( 'First Year'[Year], 'Date'[Year]) )

Value for second year = CALCULATE( [Spend Amount Original], TREATAS( 'Second Year'[Year], 'Date'[Year]) )

[amitchandak]

@tsynenkyy , Try like

Spend Selection PY = CALCULATE([Spend Amount Original],dateadd('DIM_TIME'[Date],-1,Year))

or

Spend Selection PY = CALCULATE([Spend Amount Original],SAMEPERIODLASTYEAR('DIM_TIME'[Date]))