Comparing 1 column in a table and selecting data from a 2nd column as my answer

[MPfeifer]

[Admit Less Start]           [UniqueID]
39                          001692581March62018
65                          001692581February82018
73                          001692581January312018
85                          001692581January192018
1                            001692581January312018
13                          001692581January192018
4                            001692581January192018

I am brand new to Power BI and have a question:

• In the following example I have 3 [UniqueID] that are all similar (001692581January192018).  Based on this finding I need to select [Admit Less Start] with the lowest number (my choices are 85, 13 and 4) with 4 being the one I am looking for.  
• Next there are 2 [UniqueID] that are the same (001692581January312018). I need select the lowest number between those two which is 1.

What is the best way to get this answer?

[Anonymous]

see sample

https://ufile.io/up92p

[PattemManohar · Accepted solution]

@MPfeifer Please try to group the data by UniqueID and select the Minimum "Admit Less Start" either in DAX or Power Query.

In DAX, create a "New Table" as below

Test60Out = SUMMARIZECOLUMNS(Test60Group[UniqueID],"AdmitLessStart",MIN(Test60Group[AdmitLessStart]))