GiacTorrence
New Member
- Joined
- Dec 2, 2014
- Messages
- 40
Hi all,
I'm currently working with a fairly large data set within power pivot (approximately 1 million rows of data), and am trying to find the earliest date that correspond to a range of IDs that repeat, but are scattered throughout.
For example,
1234 February 2, 2012
5555 May 2, 2004
7777 July 2, 2004
7777 May 6, 2002
1234 August 8, 1997
1234 December 12, 2012
5555 December 22, 1999
0000 August 8, 2008
0000 July 7, 2007
I tried the FIRSTDATE and MIN functions, but they didn't seem to work. Essentially, I am looking for a function that will display the earliest start date for 1234, 5555, 7777, as well as create a second calculated column to to identify the max end date (from which I could then calculate duration in a third column) etc...I'm fairly certain there is a middle-man function that's escaping me.
Any help would be greatly appreciated!
D.
I'm currently working with a fairly large data set within power pivot (approximately 1 million rows of data), and am trying to find the earliest date that correspond to a range of IDs that repeat, but are scattered throughout.
For example,
1234 February 2, 2012
5555 May 2, 2004
7777 July 2, 2004
7777 May 6, 2002
1234 August 8, 1997
1234 December 12, 2012
5555 December 22, 1999
0000 August 8, 2008
0000 July 7, 2007
I tried the FIRSTDATE and MIN functions, but they didn't seem to work. Essentially, I am looking for a function that will display the earliest start date for 1234, 5555, 7777, as well as create a second calculated column to to identify the max end date (from which I could then calculate duration in a third column) etc...I'm fairly certain there is a middle-man function that's escaping me.
Any help would be greatly appreciated!
D.
