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 column called 'Supervisor new' which copies over the data from supervisor but with the below condition.
If 'area' = '1' change 'Supervisor new' to "Alex"
If 'block' = '1b' or '1C' or '2" change 'Supervisor new' to "Dan"
Can anyone help me with the logic to achieve this?
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.
4 Replies
In power query editor go to the Add Column tab and select Conditional Column. You can put your logic in there.
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.
Try entering this into the box that comes up when you click "Custom Column"
if [Area] = 1 then "Alex" else if [Block] = "1B" then "Dan" else if [Block] = "1C" then "Dan" else if [Block] = "2" then "Dan" else [Supervisor]
