How to recreate formula from access to PowerQuery M language

[Jackie003]

Hello, 

I have a problem with such formula:

IIf([Sales Orig Area Code]>[Sales Dest Area],[Sales Dest Area] & "-" & [Sales Orig Area Code],[Sales Orig Area Code] & "-" & [Sales Dest Area]) AS [Planned OnD Area Pair vv]

I dont understand how to write it in Power Query correctly.. 

Does anyone can help with that? 

Thanks, a lot in advance 🙂 

[PhilipTreacy · Accepted solution]

Hi @Jackie003 

Try this

= if [Sales Orig Area Code]>[Sales Dest Area] then [Sales Dest Area] & "-" & [Sales Orig Area Code] else [Sales Orig Area Code] & "-" & [Sales Dest Area]

If that doesn't do what you want, please post your file and some sample data.

regards

Phil