power query editor question.

Apologies if this is in the wrong section.

I am using power query editor to clean some data before importing.
I want to convert a number to zero in one cell based on info in another cell.
It is simply if [P-Code]= 0 change value in [Unit Price] to zero, otherwise no change.

I'm only just starting and don't know the syntex for these formula's yet.

Thanks

try
Add Column - Conditional Column then set what you want to achieve

Originally Posted by sandy666

try
Add Column - Conditional Column then set what you want to achieve

Thanks Sandy, the problem is that I would need to know M language to do that as well.
I could build the formula in excel but I've never used M before.

Regards
Brian

Originally Posted by sandy666

as I said: Add Column - Conditional Column
to do it you no need to know M just use built-in functions

Attachment 820530

or try to learn from here: Conditional Column

Thanks for your help.