Skip to content
Advertisement

Tag: powerquery

Remove symmetrical records with Power Query or Python

Is there a way to remove the yellow records with Power Query, Python? They are errors and I need to get rid of them: The process could be something like: Filter the table to retrieve the rows containing only the current “CustomerID” Check the Sales. Is there any value with -Sales? And then delete those rows. Answer You may use

Advertisement