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 it is your data, what is not clear? It is taking the latest two records of each ids and then comparing the text, not sure what is not clear.
ID 1 - latest two records, the text doesn't match
ID 2 - it has only one record, so it shows matched
ID 3 - it took the latest two records, text doesn't match
how did you do it? I cannot confirm that what you did works with my data without being able to apply the results to my data. A screen shot of a table does not confirm that your solution works. Yes, those results look correct. I know what I am asking for is possible - I am asking for how to do it.