I had this question after viewing Power Query Switch Function vs If statement
After numerous hours of researching this issue for 2 days, I am really stumped.
I have tried to create a simple function of either If or Switch and both return the above mentioned error.
I even created a sample based on the example supplied on MSDN for the IF Function, trying to use it both in the Power BI Desktop and/or Power Query for Excel 2013 (32 bit) environments. Without any luck.
I am using the latest download of Power query and PBI, I just set up my computer in the last week. Urgently need of help.