Forum Discussion

joep78's avatar
joep78
Icon for Helper III rankHelper 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's avatar
    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's avatar
Fowmy
Icon for Super User rankSuper 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's avatar
    joep78
    Icon for Helper III rankHelper III
    5 years ago

    Hi Fowmy,

     

    Thanks for this solution, this is really helpful! 

     

    Regards,

     

    Joep