Power Query If function for multiple conditions

[Anonymous]

Hallo all,

I would like to add a custom column with the folwing condition

if(if [code] = "50" and [Cont] = "91" then "1EN") and if [code] = "44" and and [Cont] = "91" then "2EN" else [Code]

Could you please help out how to write it?

[amitchandak · Accepted solution]

@Anonymous , Try like

if [code] = "50" and [Cont] = "91" then "1EN" else
if [code] = "44" and and [Cont] = "91" then "2EN" else [Code]