Forum Discussion
Recreate command from Access to PowerQuery
Forget about it! I did it by myself. The solusion is:
if [Sales Country Code]=[Sales Orig Country Code] then
(if ([Supplier] = "LH" and [Sales Dest Country]="DE") or ([Supplier] = "LX" and [Sales Dest Country] = "CH")or ([Supplier]="OS" and [Sales Dest Country]="AT") or ([Supplier]="SN" and [Sales Dest Country]="BE")
then "P2P"
else (if [Sales Dest Area]="EU" then "EU<>P2P" else [Sales Dest Area]))
else (if [Sales Dest Country]=[Sales Country Code] then "XBorder" else "Transversal")
Forget about it! I did it by myself. The solusion is:
if [Sales Country Code]=[Sales Orig Country Code] then
(if ([Supplier] = "LH" and [Sales Dest Country]="DE") or ([Supplier] = "LX" and [Sales Dest Country] = "CH")
or ([Supplier]="OS" and [Sales Dest Country]="AT") or ([Supplier]="SN" and [Sales Dest Country]="BE")
then "P2P"
else (if [Sales Dest Area]="EU" then "EU<>P2P" else [Sales Dest Area]))
else (if [Sales Dest Country]=[Sales Country Code] then "XBorder" else "Transversal")