How to summarize earliest worked date per person?

powerpivotlegal

New Member
Joined
May 14, 2014
Messages
30
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
Joined
Apr 29, 2014
Messages
101
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
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top