Adding one value from one measure to all elements of another measure

[SEZA]

Hi,

I need help to solve the following problem. I have created 2 measures (M1 and M2). I would like to create another measure (Result) where I can add the last value of M2 (value from year 2011) to all the values of M1 (starting from 2012).  My desired result would be "Result" but I get the "Bad-Result" as final result which I gained from simply doing:

[M1] + [M2]

If I have a simple value e.g. 2 the above formula works: 2 + [M1] gives me: 7 ,9 , 5, 6 starting from year 2012. But this doesn't work if I add up 2 measures.

Please help. Thank you in advance.

[wdx223_Daniel]

@SEZA Years in the row comes from Date Table

[amitchandak]

@SEZA , Try a measure like

measure =
var _max = maxx(filter(values(Table[Year]), not(isblank([M2]))), Table[Year])
return
calculate([M2], filter(all(Table), Table[Year] =_max)) +[M1]