How to create column that counts the specific duplicate entry in the table

Hi sjpbi ,

Please follow these steps:

1.In Power Query -- add Column – Index Column – From 1.

the results are shown below.

2.Create a calculated column and write the following expression.

Count Column = COUNTROWS(FILTER('Table','Table'[RequestID] = EARLIER('Table'[RequestID]) && 'Table'[Index] <= EARLIER('Table'[Index])))

3.The final result is shown below.

If you don't want the index column to appear in the report, you can hide it by clicking on the small eye to its right.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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