Forum Discussion
Copy column in Power Query based on condition
Hi, I have a dataset similar to the below. Supervisor Area Block Alan 1 1A Marc 2 1B Alan 3 1C John 4 1C Fred 5 2 Fred 5 4 I want to create a new col...
you could edit the code in Advanced Editor. put the basic logic in using the Conditional Column functionality and then edit the code that is generated to add in any additional logic you need.
In power query editor go to the Add Column tab and select Conditional Column. You can put your logic in there.
After playing around with the conditional column function, I do not see how this can be achieved due to the 'Else if' section not supporting 'and' statements.
Any ideas?
you could edit the code in Advanced Editor. put the basic logic in using the Conditional Column functionality and then edit the code that is generated to add in any additional logic you need.