Calculate start value versus final period

[joep78]

Hi all,

I'm looking for a solution that calculate the difference between my start value and the target value in the final period:

Target	value
A	1200
year	Forecast
2020	1100
2021	100
2022	900

In this example I expect that answer will be 300 (1200 as target minus 900 of the final year) 

Not sure how to deal with this, could be simple but not for me! Thanks in advance for a reply. 

Regards, Joep

[Fowmy · Accepted solution]

@joep78 

Create a measure as follows:

M = 
var __year = CALCULATE( max(table[year]) , all(table])) return

var __lastvalue = CALCULATE( sum(table[forecast]), table[year] = __year )

return

max(target[value]) - __lastvalue

[joep78]

Hi Fowmy,

Thanks for this solution, this is really helpful! 

Regards,

Joep