Calculate cumulative count by looking values in a column

[n2p2gupta]

How can I create a column "Result" below by keepin a count of repeating values from Col1?  Thanks.

Col 1    Result

   a              1

   b              1

   a              2

   c              1

   b             2

   a             3

   c             2

[n2p2gupta]

Thanks Eric!

[Eric_Zhang]

---

@n2p2gupta wrote:

Thanks Eric!

---

@n2p2gupta

If you have no further question, could you accept the reply as solution to close this thread? For any question, feel free to post.

[Eric_Zhang]

---

@n2p2gupta wrote:

How can I create a column "Result" below by keepin a count of repeating values from Col1?  Thanks.

Col 1    Result

   a              1

   b              1

   a              2

   c              1

   b             2

   a             3

   c             2

---

@n2p2gupta

You need an index column to indicate the rows order.

Then create a calculated column as

Result =
RANKX (
    FILTER ( 'Table', 'Table'[Column1] = EARLIER ( 'Table'[Column1] ) ),
    'Table'[Index],
    ,
    ASC,
    DENSE
)