Forum Discussion
Solved
How to recreate formula from access to PowerQuery M language
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 🙂
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
1 Reply
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