The Advanced Editor edits the whole query. A let expression names intermediate values, and in chooses the value you return. Each binding ends with a comma except the last. Names with spaces use #"Quoted identifiers". Changing the value after in can return an earlier step even when a later transformation is correct.
Your supplied Raw query contains fictional service batches. Keep that staging query intact and edit Work. Its M can refer to Raw by name, so the result changes when a new extract arrives. A table written with #table is useful for examples, but copying today's rows into it would freeze the answer. These tasks ask for repeatable transformations. Check the columns as well as the rows: a correct filter returned from the wrong binding can still have extra fields.