I have some data about projects I would like to transform in a way that makes it easier to analyse with PowerBi. The data looks like this: Project Number Project Name Planned Start Date SM1 SM2 SM3 10000 A Apr-21 10 20 30 10001 B Jun-21 40 50 60 10002 C Sep-22 70 80 90 The so called ‘SavingMonths’ are
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