Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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] ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

     

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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

 

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