tried to create new Custom column like this :
IF([SalesOrderOriginCode] = "PHONE", "PHONE",
IF(Text.Start([InvoiceAddressCity],1)= "A", "LOCAL","EXPORT")
No syntax error, but after press ok, it says The name IF wasn't recognized. What's wrong ?
Solved! Go to Solution.
@VoltesDev seems like you are adding this in Powe Query
if [SalesOrderOriginCode] = "PHONE" then "PHONE" else if Text.Start([InvoiceAddressCity],1)= "A" then "LOCAL" else "EXPORT"
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.