Measure's value at the end of previous year

[JPO_10]

Hi all,

With the help from @amitchandak  and @v-cgao-msft  I managed to get previous year's closing values from column. Thank you, guys.

Now the problem is to get last year's closing value from measure. Measure itself work perfectly. Also SAMEPERIODLASTYEAR looks good. ROCE is calculated as follows:

ROCE =

VAR Profit = [Income, ROCE]

VAR _Month = DATES[Month, measure]

VAR _Inv = ([Investment opening] + [Investment]) / 2

Return

((Profit / _Month) *12) / _Inv

For ROCE_LY_EOY I have tried 

ROCE_LY_EOY = CALCULATE(

                ROCE[ROCE],

                DATEADD(ENDOFYEAR(DATES[Date]),-1,YEAR)

)

Instead of zeros in ROCE_LY_EOY, it should be 62,5% for this year.

Hope you can help.

Cheers,

J

[johnt75 · Accepted solution]

you could try

ROCE_LY_EOY =
VAR CurrentYear =
    YEAR ( MAX ( 'Dates'[Date] ) )
VAR LastYear = CurrentYear - 1
RETURN
    CALCULATE (
        ROCE[ROCE],
        REMOVEFILTERS ( 'Dates' ),
        TREATAS ( { ( LastYear, "December" ) }, 'Dates'[Year], 'Dates'[Month name] )
    )

[nateschultz]

Thank you @johnt75 for helping out!

[JPO_10]

Hi @johnt75 ,

your solution solved my problem!

Many Thanks,

J