Last Row column value

[sunil-kumar5]

Hello All,

Please help to get a KPI value from below table, I want the last row value from value1 should reflect in KPI that is 383.

Year	Month	value1	value2	value3
2021	May	245	275	225
2021	June	412	493	418
2021	July	421	382	227
2021	Aug	383	435	349

Please advice

[Saravanan_Desingh · Accepted solution]

Try something like this,

=FirstSortedValue(value1,-Date(Date#(Month,'MMM')))

[Saravanan_Desingh]

Also try with Year,

=FirstSortedValue(value1,-Date#(Month&Year,'MMMYYYY'))

[sunil-kumar5]

Hi Saran,

It is working absolutely fine Thanks for your help.