Recreate command from Access to PowerQuery

[Jackie003]

Hello, 

I would like to recreate query from Access to PowerQuery M language, but I have a problem to do it. Could you help me with that?

IIf (Pivot1.[Sales Country Code]=Pivot1.[Sales Orig Country Code],
IIf((Pivot1.Supplier="LH" And Pivot1.[Sales Dest Country]="DE" ) OR (Pivot1.Supplier="LX" And Pivot1.[Sales Dest Country]="CH" )
OR (Pivot1.Supplier="OS" And Pivot1.[Sales Dest Country]="AT" ) OR (Pivot1.Supplier="SN" And Pivot1.[Sales Dest Country]="BE" ),"P2P",
IIF(Pivot1.[Sales Dest Area]="EU","EU<>P2P",Pivot1.[Sales Dest Area])) ,
IIF(Pivot1.[Sales Dest Country]= Pivot1.[Sales Country Code], "XBorder","Transversal" )) AS [O&D Traffic],

[Jackie003 · Accepted solution]

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")