Identify value of something at a minimum and maximum of the selected dates

[#1]

Hi,

Am am trying to calculate a metric to describe how something has changed over time but I am unsure how to begin coding this. Core to this is that I want to be able to identify what a value (rating) is for a minumum and maximum of the selected dates. The dates may not always be the full range of the data and so I don't think I can do if(min(date) ....).

Thanks for help in adavance,

Isabel

[#2 · Accepted solution]

I have now solved this. The top line gives me the performance rating at the minumum and maximum of the seleected dates whilst the bottom line simply calculates the number of years that have passed:

=((sum({<[Year]={"$(=vMax_date)"}>} [Performance Rating])) - (sum({<[Year]={"$(=vMin_date)"}>} [Performance Rating])))
/
((vMax_date)-(vMin_date))