Earliest "Date Entered" for a key with multiple entries

[RedTangerine]

I am trying to create a new tables that extracts the Earliest "Date Entered" for a key with multiple entries.

Each of my Entries has an Entered Date and an Incident ID. But as incidents updated new copies come along with new ID and Entered Dates.

So I end up with:

ID                            Entered Date

1                              1/2/15

1                              2/3/15

2                              3/3/15

3                              7/6/15

3                              5/2/15

I need to extract only the ID and Earliest Entry Date.
Unfortunetly the unique ID key is out of order so I need to use teh ID and Entered Date.

Using the Table above only the bolded

ID                  Entered Date

1                              1/2/15

1                              2/3/15

2                              3/3/15

3                              7/6/15

3                              5/2/15

New Table

ID                  Entered Date

1                              1/2/15

2                              3/3/15

3                              5/2/15

[v-yulgu-msft · Accepted solution]

Hi @RedTangerine,

You could try to create a calculated table like this:

Filter table = SUMMARIZE(Entry,Entry[ID],"Date",min(Entry[Entered Date]))

Above table won't be dynamically updated if you apply any slicer/filter in report page. If the data source is refreshed, please click the "Refresh" button manually, above table will update data.

Regards,

Yuliana Gu

[Ashish_Mathur]

Hi,

In the visual, drag ID to the row labels and write the following measure

=MIN(Data[Entered Date])

[RedTangerine]

Are you able to expand upon your answer. 
Will what your describing create a filtered table....

[Ashish_Mathur]

Hi,

No.  It will not create a filtered table.  It will create an actual visual.

[RedTangerine]

unfortunately I need it filtered to new table as I need to compare earliest entered date to another date field occurred date. 
Comparing how long it took to enter the incident into the database compared to the date that it occurred.