Kpi with a condition

[eyefault]

Hi guys,

Data is similar a show below;

Period	Revenue
202301	20
202301	30
202301	40
202302	50
202302	60
202303	70

How can be function can I show the total revenue in kpi in the maximum period condition.

Query result should be used 70 in KPI

[Or]

FirstSortedValue(Revenue, -Period)