Last figure

[bobbydave]

Test:
LOAD * INLINE
[myDate, Utilisation, Capacity (23.3TB)
25/07/2016, 92.62, 22.105
01/08/2016, 91.69, 21.883
08/08/2016, 91.08, 21.738
15/08/2016, 91.38, 21.809
22/08/2016, 91.85, 21.921
29/08/2016, 91.85, 21.921
07/09/2016
08/09/2016
10/09/2016
];

Imagine myDate is infinite. I would like to get the last Utilisation figure 91.85 without explicitly saying myDate= 29/08/2016

I am trying to get the logic behind it.

//sum({< myDate >}Utilisation

[effinty2112 · Accepted solution]

Hi David,

try:

=FirstSortedValue({$<Utilisation ={">0"}>}Utilisation,-myDate)

Kind regards

Andrew

[Chanty4u]

try this in front end

=FirstSortedValue(Utilisation,-myDate)

[Anonymous]

Try This,

=sum({<myDate = {"=Max(Date)"}>}Utilisation)

[Kushal_Chawda]

try this

=sum({<Date={"$(=date(max({<Utilization={">0"}>}Date)))"}>}Utilization)