count adding one to each count made

[William_Moreno]

Hi everyone,

I have a table with the order code, as you see below, the code appears 3 times, I woud like to create a column to count without repeating the number "3", but count adding one to each count made. 

order-number	Count	Correct Count
100500500	3	1
100500500	3	2
100500500	3	3

Thanks

[harshnathani · Accepted solution]

Hi @William_Moreno ,

One way would be

Create an index Column in Power Query.

Then create a  Calculated Column

Correct Count Column = RANKX(FILTER('Table','Table'[order-number] = EARLIER('Table'[order-number])),'Table'[Index],,ASC,Dense)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)