Get value of column in a group based on the min value of another column in that group

[dthompsonKairos]

I apparently cannot adequately formulate a search term to get what I want so I'm posting this. And to save time, it can be boiled down to a picture:

Simply put, I want to retrieve the value of the third column, from the group based on the left column, for the earliest date in the second column.

A measure would be fine. I could also do a calculated table.

I've tried many of the proposed solutions but none seem to work the way I need.

The table itself is not previously grouped.

[ajaybabuinturi · Accepted solution]

Hi @dthompsonKairos,
I am not what your looking for. I am assuimg you need to find the lowest/last Period KPI value based on KPI.
You can try below formula

Earliest KPI Value = 
VAR EarliestDate =
    CALCULATE(
        MIN('Table'[PERIOD]),
        ALLEXCEPT('Table', 'Table'[KPI])
    )
RETURN
    CALCULATE(
        MAX('Table'[KPI_VALUE]),  -- Use MAX if date is unique per KPI
        'Table'[PERIOD] = EarliestDate
    )

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.