Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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
@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
Is there a way to do this in M Code in Excel?
I did manage to do this by splitting into columns using a delimiter and then unpivot command.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |