# 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.

#### 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

1,078,437
Messages
5,340,278
Members
399,362
Latest member
iayb

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...