# How to summarize earliest worked date per person?

#### powerpivotlegal

##### New Member
Hello,

I have the following sample data set. I have a timekeeper lookup table with status (approved, etc.) linked to this data. I am trying to find the earliest date that each person worked, so that I can determine when each timekeeper started billing and if they are brand-new (i.e. not on the approved list).

How can I write DAX formula to handle this?
 Matter Name TK # TK Name TK Title TK GPG TK Office Work Date Work Value IP Rights Analysis - Tax 45587 Smith, John Associate Tax Palo Alto 20 Feb 2014 252.00 IP Rights Analysis - Tax 45587 Smith, John Associate Tax Palo Alto 28 Feb 2014 720.00 IP Rights Analysis - Tax 45587 Smith, John Associate Tax Palo Alto 28 Feb 2014 0.00 IP Rights Analysis - Tax 45587 Smith, John Associate Tax Palo Alto 6 Mar 2014 900.00 IP Rights Analysis - Tax 45587 Smith, John Associate Tax Palo Alto 7 Mar 2014 2,628.00 IP Rights Analysis - Tax 45587 Smith, John Associate Tax Palo Alto 9 Mar 2014 900.00 IP Rights Analysis - Tax 45587 Smith, John Associate Tax Palo Alto 31 Mar 2014 0.00 IP Rights Analysis - Tax 45587 Smith, John Associate Tax Palo Alto 21 Apr 2014 0.00 IP Rights Analysis - Tax 41833 Johnson, Ben Sr. Analyst Tax San Francisco 25 Mar 2014 1,349.00 IP Rights Analysis - Tax 41833 Johnson, Ben Sr. Analyst Tax San Francisco 31 Mar 2014 0.00 IP Rights Analysis - Tax 41833 Johnson, Ben Sr. Analyst Tax San Francisco 21 Apr 2014 0.00 IP Rights Analysis - Tax 46113 Davis, Mark Tax Director Tax London 19 Jun 2014 900.00

<tbody>
</tbody>

Many thanks.

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### Tianbas

##### Board Regular
Add the following Calculated Column to your table to flag the row with the start date of the person
=if(Table1[Work Date]=calculate(min(Table1[Work Date]),filter(table1,Table1[TK name]=Earlier(Table1[TK Name]))),"Start","")

This flag you can use in other columns or measures to crosscheck with your approval list

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,714
Messages
5,833,281
Members
430,201
Latest member
Deepakpilla36

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back