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...
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.