Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try something like this,
=FirstSortedValue(value1,-Date(Date#(Month,'MMM')))
Try something like this,
=FirstSortedValue(value1,-Date(Date#(Month,'MMM')))
Also try with Year,
=FirstSortedValue(value1,-Date#(Month&Year,'MMMYYYY'))
Hi Saran,
It is working absolutely fine Thanks for your help.