Combine Rows and Select Earliest Date

[slounsbury]

I am wanting to combine rows that have like ticket numbers and create a new column that will only display the the ealierst date from those tickets. I am fairly new to PBI so I apologize if more info is needed or is not detailed correctly.

Currently the table looks like this:

SR_Service_RedID	Entered_By	Time_Start_UTC	Time_End_UTC
123456	joe	11/6/17 8:30 PM	11/6/17 9:30 PM
123456	bob	11/7/17 10:30 PM	11/7/17 11:00 PM
123456	tim	11/8/17 6:30 PM	11/8/17 7:00 PM
987654	bob	12/6/17 6:30 PM	12/6/17 7:00 PM
987564	joe	12/12/17 9:30 PM	12/12/17 10:00 PM
987654	tim	1/11/18 6:30 PM	1/11/17 7:00 PM

I am the new column to just display the first time entry on the ticket like this:

SR_Service_RedID	Entered_By	Time_Start_UTC	Time_End_UTC	First_Time
123456	joe	11/6/17 8:30 PM	11/6/17 9:30 PM	11/6/17 8:30 PM
123456	bob	11/7/17 10:30 PM	11/7/17 11:00 PM	11/6/17 8:30 PM
123456	tim	11/8/17 6:30 PM	11/8/17 7:00 PM	11/6/17 8:30 PM
987654	bob	12/6/17 6:30 PM	12/6/17 7:00 PM	12/6/17 6:30 PM
987564	joe	12/12/17 9:30 PM	12/12/17 10:00 PM	12/6/17 6:30 PM
987654	tim	1/11/18 6:30 PM	1/11/17 7:00 PM	12/6/17 6:30 PM

Or somehow create a column that marks the first time and then I can sort it out while making the report.

Thanks!

[slounsbury · Accepted solution]

Was able to figure out how to create the column by using:

column = CALCULATE(MIN(Time_Entry[Time_Start_UTC]), FILTER(Time_Entry, Time_Entry[SR_Service_RecID]=EARLIER([SR_Service_RecID])))