Forum Discussion
populating a column based on value in another column
Hi All,
I'm sure this has been answered before, but i've spent an hour looking for it and so far haven't been able to find what i need.
I have 3 columns shown below, what i need to do is take the status = done, take the weight and put the weight into the value column, if the status is not done put a 0.
| status | Weight | value |
| new | 75 | 0 |
| new | 10 | 0 |
| new | 5 | 0 |
| done | 5 | 5 |
| done | 5 | 5 |
| inprogress | 10 | 0 |
| inprogress | 5 | 0 |
Any help gratefully received.
Thanks,
Jeff
Hi Anonymous ,
You could do this in Power query using the 'Add Conditional Column',
which will give you
