Earliest date and other fields associated with that date using DAX

[ryan_b_fiting]

Hello Community - 

I am in need of some help with getting the earliest dates and some of the other fields associated with those earliest dates.  Below is a sample shot of my data.

So what I am trying to do is find the earliest enrolled date, and the earliest course code.

For example for leaner 000039 I would anticipate seeing 28-May-20 and DBW6350 for the two data points mentioned.

Thank you for your help

Ryan F.

[Greg_Deckler · Accepted solution]

@ryan_b_fiting - Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

[ryan_b_fiting]

@Greg_Deckler worked just as expected, perfect.

Thank you!