Forum Discussion
add numerical correlative
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
Hi,
The answer in the second row should be 1. You may download my PBI file from here.
Hope this helps.
4 Replies
- AllisonKennedy
Community Champion
jrobles Is this what you're looking for? https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
- amitchandak
Super User
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])
- Ashish_Mathur
Hi,
The answer in the second row should be 1. You may download my PBI file from here.
Hope this helps.
thanks, they are the best
gracias, son los mejores, los mas pulentos
