Forum Discussion
Comparing structured Lists with previous row
Hello Power Query experts,
I have hit a wall and have been struggling to get a solution.
So my requirement is to compare the list in a column with that of previous row and find out difference...
If you can let us know the final result, we can rework the approach. I think approach needs a change here.
Looaking for a solution like this:
Month Id 1/1/2021 1 1/1/2021 2 1/2/2021 1 3 added in this month 1/2/2021 2 3 added in this month 1/2/2021 3 3 added in this month 1/3/2021 1 2 missing from this month 1/3/2021 3 2 missing from this month My apologies to come back on this. Can you please post the final result which you want? I went through your expanation but I am unable to conceptualize the final table which you need. If you can post the final result table, that would be great.
