Forum Discussion
Solved
Compare text value row data in PBI
I have a dataset that has been built that includes version history. Some items have multiple versions, while newer ones only have a single row. The data get refreshed weekly. I am wanting to com...
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.
