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