how to get values related to MIN or MAX

[mark1]

I'm hoping this is fairly simple but I've been unable to find any existing reference to my specific question...

I understand how to use MIN or MAX to find the minimum or maximum value in a given column, but I'm not sure how to retrieve other values related to the MIN or MAX value. 

For example, given the dataset below, the MIN cost is 19.55. How can I create a measure that returns either the date (1/7/2020) or name (Harold) that are associated with this minimum cost value?

Similarly, given the dataset below, the MAX cost is 21.92. This cost is associated with two different dates and names. How can I create a measure that lists the names assocuated with this maximum cost, or returns the earliest or latest date associated with this maximum cost?

Date	Cost	Name
1/1/2020	20.12	David
1/2/2020	20.15	Susan
1/3/2020	20.18	Mike
1/4/2020	20.18	Paul
1/5/2020	20.18	John
1/6/2020	20.18	Mary
1/7/2020	19.55	Harold
1/8/2020	19.86	Ben
1/9/2020	19.82	Chris
1/10/2020	19.80	Julie
1/11/2020	19.70	Peter
1/12/2020	19.71	Henry
1/13/2020	19.98	Matt
1/14/2020	20.06	Jon
1/15/2020	20.09	Bret
1/16/2020	20.12	Byron
1/17/2020	20.20	Leah
1/18/2020	20.25	Oswald
1/19/2020	20.29	Jasmine
1/20/2020	21.50	Robert
1/21/2020	21.82	Donald
1/22/2020	21.11	Erik
1/23/2020	21.91	Richard
1/24/2020	21.92	Tammy
1/25/2020	21.92	Tia
1/26/2020	21.10	Greg
1/27/2020	20.65	Valerie
1/28/2020	20.62	William
1/29/2020	20.62	Kathy
1/30/2020	20.65	George
1/31/2020	20.66	Nathan

[Greg_Deckler · Accepted solution]

@mark1 (1) Lookup Min/Max - Microsoft Fabric Community

[ThxAlot · Accepted solution]

[Greg_Deckler · Accepted solution]

@mark1 (1) Lookup Min/Max - Microsoft Fabric Community