Forum Discussion

Helper III

5 years ago

Solved

Calculate start value versus final period

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...

Need Help

Fowmy

5 years ago

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

Fowmy

Super User

5 years ago

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

Helper III

5 years ago

Hi Fowmy,

Thanks for this solution, this is really helpful!

Regards,

Joep