Date conditional KPI

[eyefault]

Hey,

How can I make a collection sum to maximum date KPI ?

Example:

Period	Revenue
202301	10
202301	15
202302	20
202302	20
202303	25
202303	15
202303	30

Might be result 70

I need Total 2023 revunue but function but the function should be dynamic, it should give the maximum date instead of the sum of 202303. 

[priyanka181088]

FirstSortedValue(Period, -Aggr(Sum(Revenue), Period))

i hope this helps

[eyefault]

Nope 😞 it works but wrong resul. I tried with the following function, but I couldn't do Sum

Date(Max(Period)-1) 

[BrunPierre]

@priyanka181088 What do you expect as output?

[eyefault]

25+15+30 = 70

[BrunPierre]

Sum( {$<Period = {"$(#=Max(Period))"}>} Revenue)