Why does a reference to a value in previous row throw this Expression Error

Question

I am trying to perform an operation in Excel using Powerquery. as well as Power BI

I want to remove contacts in a list if they are connected to a certain CompanyID but are listed with a different CompanyName.

The fist step is to filter them out by comparing to the row above. They are always listed consecutively.

Next step is to remove all rows containing the value delete in the delete column but unfortunately I do not get to that step.

I get this error:

There were too many elements in the enumeration to complete the operation

Answer 1

If you have multiple steps after the #"Added Index" that might change your data.

The current step will refer to the data as it appears in the #"Added Index" step.

Any changes that are performed after the #"Added index" step will not be available to the statement.

You may want to adjust your posted step to use the latest representation of your data instead of #"Added index".

If #"Added index" is the most recent step in your M code, the statement runs fine, so the problem is that the data is changed in the steps in between.

Adjust the statement to refer to the most recent data step instead of #"Added index".