Forum Discussion
create index from existing data with duplicates
Hi folks, Can anyone help me with this one? I have a column of data which includes duplicates which I want to add a sequence number to so they become unique. e.g. F01 F01 F02 F03 would become F01-1 F01-2 F02-1 F03-1 I can think of a long-winded way to do it but I suspect there is an easy way.
Anonymous , first of add index in power query
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
then create a new column in dax like this
New column = [Column1] & " - " & countx(filter(Table, [Column1] = earlier([Column1]) && [index] <= earlier([index])),[Column1])
assume Column1 is the column having F01 F01 F02 F03
3 Replies
- amitchandak
Super User
Anonymous , first of add index in power query
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
then create a new column in dax like this
New column = [Column1] & " - " & countx(filter(Table, [Column1] = earlier([Column1]) && [index] <= earlier([index])),[Column1])
assume Column1 is the column having F01 F01 F02 F03