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
5 Replies
Hi Anonymous
You need to select "Transform Data" and then you should be able to action AntonioM's reponse from there.
Alex
Hi Anonymous ,
You could do this in Power query using the 'Add Conditional Column',
which will give you
Hi AntonioM ,
I'm going to accept this as the solution, as I am sure that is the way to do it, but my powerBI doesn't have that add column tab, will have to find out how to get that.
Thanks,
Jeff
Hi Jeff, that's because AntonioM says to do it in Power Query, not in Power BI. To go there, you have to click on the “Transform Data” button (it appears in your picture) and then follow his instructions.
Greetings.
