populating a column based on value in another column

[Anonymous]

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

[AlexSpencer]

Hi @Anonymous 

You need to select "Transform Data" and then you should be able to action @AntonioM's reponse from there. 

Alex 

[Anonymous]

Hi @AlexSpencer,

Thanks, i found it at last.

BR,

Jeff

[AntonioM · Accepted solution]

Hi @Anonymous ,

You could do this in Power query using the 'Add Conditional Column',

which will give you

[Anonymous]

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

[pifernan]

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.