Forum Discussion
Adding Number Column based on the Row Value for huge Data Sets
I have a single CSV containing 5000 sets of data. Each set of data is identified by the value in the first row at the start of each data set. I'd like to create a column identifier from the row set...
Hi Anonymous
please check out this post: https://community.powerbi.com/t5/Desktop/Grouping-multiple-rows/m-p/969739#M464286
First you add an index column to your table and then another column that checks if the text starts with "loop". If so, then return the index-column if not, return null. Then fill down that new column and you have your groups. If you need a sequential numbering without gaps, check the 2nd sample in that blogpost how to proceed.
v-juanli-msft
Community Support
Community SupportHi Anonymous
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?
If not, please feel free to let me know.
Best Regards
Maggie
It was solved but I solved it on my own with sheer desperation.
Though the solutions provided on this thread were much better and are very similar to what I concocted.
Some of which I will adopt myself.
Thank you community.
Ron