Forum Discussion
Power Query If function for multiple conditions
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?
Anonymous , Try like
if [code] = "50" and [Cont] = "91" then "1EN" else
if [code] = "44" and and [Cont] = "91" then "2EN" else [Code]
1 Reply
Anonymous , Try like
if [code] = "50" and [Cont] = "91" then "1EN" else
if [code] = "44" and and [Cont] = "91" then "2EN" else [Code]