power query

Hi AKARSEVGI ,

 

Your ideal could be like this:-

if [SALRESP]="SEA"
  then "HAUS SEA" 
else if [SALRESP]="INDIA" 
  then "HAUS SA" 
else if [SALRESP]="HAUS EUROPE" 
  then "HAUS EUROPE" 
else if [SALRESP]="ASS" 
  then "AFTER SALES" 
else if [COGRP]="IBERIA" 
  then "IBERIA" 
else if [CONAME]="Türkiye"
  then "TURKEY" 
else if [COUNTRY]="IT"
  then "ITALY" 
else if [SALDEPTENAME]<>"OLIVE OIL" 
  then "OTHER REGIONS" 
else if [COUNTRY]="MA" 
  then "MOROCCO"
else if [COUNTRY]="TN" 
  then"TUNISIA" 
else if [COUNTRY]="DZ" 
  then "ALGERIA" 
else if [COUNTRY]="EG" 
  then "EGYPT" 
else if [COUNTRY]="Greece" 
  then "GREECE"
else "OTHER REGIONS"

 

Thanks,

Samarth