Group By ID and rank it in sequence of date

[Anonymous]

I have data in a below mentioned format. I am trying to add new column which will give rank to the row by Modified Date and group by Number. 

Data:

Number	Modified Date
8028999	4/18/2019 12:40 PM
8028999	4/1/2019 6:28 AM
8028999	4/17/2019 10:38 AM
8028999	4/1/2019 6:28 AM
8029134	4/15/2019 3:58 PM
8029134	4/1/2019 7:46 AM
8029134	4/1/2019 7:46 AM
8029134	4/15/2019 3:58 PM
8032640	4/1/2019 9:38 PM
8032640	4/2/2019 3:47 PM
8032640	4/1/2019 9:38 PM
8032640	4/1/2019 9:41 PM
8032819	4/2/2019 2:52 PM
8032819	4/1/2019 10:06 PM
8032819	4/2/2019 2:50 PM
8032819	4/1/2019 10:06 PM
8032840	4/1/2019 10:09 PM
8032840	4/1/2019 10:10 PM
8032840	4/17/2019 10:48 AM
8032840	4/23/2019 3:07 PM
8032840	4/22/2019 9:18 PM
8033409	4/1/2019 11:42 PM
8033409	4/1/2019 11:42 PM
8033409	4/17/2019 10:32 AM
8033409	4/17/2019 11:17 PM
8034079	4/2/2019 1:14 AM
8034079	4/2/2019 6:53 AM
8034079	4/2/2019 1:14 AM
8034079	4/10/2019 9:46 PM

Expected Result

Number	Modified Date	DuplicateNumber
8028999	4/18/2019 12:40 PM	3
8028999	4/1/2019 6:28 AM	1
8028999	4/17/2019 10:38 AM	2
8028999	4/1/2019 6:28 AM	1
8029134	4/15/2019 3:58 PM	2
8029134	4/1/2019 7:46 AM	1
8029134	4/1/2019 7:46 AM	1
8029134	4/15/2019 3:58 PM	2
8032640	4/1/2019 9:38 PM	1
8032640	4/2/2019 3:47 PM	3
8032640	4/1/2019 9:38 PM	1
8032640	4/1/2019 9:41 PM	2
8032819	4/2/2019 2:52 PM	3
8032819	4/1/2019 10:06 PM	1
8032819	4/2/2019 2:50 PM	2
8032819	4/1/2019 10:06 PM	1
8032840	4/1/2019 10:09 PM	1
8032840	4/1/2019 10:10 PM	2
8032840	4/17/2019 10:48 AM	3
8032840	4/23/2019 3:07 PM	5
8032840	4/22/2019 9:18 PM	4
8033409	4/1/2019 11:42 PM	1
8033409	4/1/2019 11:42 PM	1
8033409	4/17/2019 10:32 AM	2
8033409	4/17/2019 11:17 PM	3
8034079	4/2/2019 1:14 AM	1
8034079	4/2/2019 6:53 AM	2
8034079	4/2/2019 1:14 AM	1
8034079	4/10/2019 9:46 PM	3

[v-yuta-msft]

@Anonymous ,

Create a calculate column using DAX below:

DuplicateNumber = RANKX(FILTER('Table', 'Table'[Number] = EARLIER('Table'[Number])), 'Table'[Modified Date], , ASC, Dense)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for the response. I did try the DAX formula you provided. But it does not gives me duplicate number in sequence of date/time. 

[v-yuta-msft]

@Anonymous ,

So what's your requirement and expected result? Could you share more details?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.