Forum Discussion
Compare text value row data in PBI
Managed to solve it by creating a Partition and geneating an index column for each ID, the expanding the partition, creating a calculation column that increases the existing index by 1, then merging on the index columns.
klili I'm just asking if the result based on the sample data is correct or not and if you had simply confirmed it, I would have provided you the solution but rather I'm getting all sorts of replies. I hope someone else can help, although I already created the solution I'm having a hard time getting a simple answer. Thanks!!
What you posted simply wasn't clear to me. More detail as to "is this the result you are looking for" would have helped. because yes, what you sent was correct. I am sorry that a couple replies back and forth is not something you are willing to do when I was confused. I hope you have more patience with others!