KPI to Show Current Year Data Only

[jennifej]

Hi there! I am trying to calculate a KPI with two fields and only the current year (2021) data but the set of data I am working with has data from previous years. 

1. I need to separate and display the Test Name (there are 3 different types of tests within the field and I want to show a KPI for each test separately)
2. I need to exclude all Test Dates prior to 2021 (or only include test dates from 2021 and forward)

Any insight would be much appreciated.

Thanks!

[Anil_Babu_Samineni · Accepted solution]

Hello, Not sure you expected based on a test for KPI, But this can be done?

FirstSortedValue(testname, -Aggr(Your expression, Dimension), 1)