add numerical correlative

[jrobles]

hi, i need to add a new column with running count, based on existing columns. How do I generate the ID column?

FORMATO	PRODUCTO		ID
A	892484		1
A	895524		2
A	1057696		1
A	1057696		2
A	1057696		3
A	1057698		1
B	1049710		1
B	1049710		2
B	1047274		1
B	1047274		2
B	1047274		3

I need to add a unique id in each repeated value

[jrobles]

thanks, they are the best

gracias, son los mejores, los mas pulentos

[Ashish_Mathur · Accepted solution]

Hi,

The answer in the second row should be 1.  You may download my PBI file from here.

Hope this helps.

[amitchandak]

@jrobles , First of all, add an index column in power query and then try this as a new column in DAX -https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

countx(filter(Table, [FORMATO] = earlier([FORMATO]) && [PRODUCTO] = earlier([PRODUCTO]) && [Index] <=earlier([Index]) ),[Index])

[AllisonKennedy]

@jrobles  Is this what you're looking for? https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query