Adding Customer Column in Power Query, No Syntax Error Detected when there is no code added?

[_eteamidc]

Thank you for your response. I have a PRO license and this banner started to show (didn't before)
Could this be the 1 GB limitation? Once I add the code for the Custom Column, then the green check mark shows but still within this red/orange banner with /Null/Error in the new Custom Column.

[_eteamidc]

Hello All, this error has sorted itself out.

Thank you all for your replies and assistance.
I do not see this error message anymore on an empty Power Query Editor/Add Custom Column Formula

Cheers

[DonutsFearMe]

I'm having this exact same issue.  Only difference is that I don't have the PRO license.

My experience:

First off, I'm new to Power BI, and was in the middle of a tutorial when this issue popped up.  I was given two columns of data.  I need to add the data across the rows of each column together, then divide the results by 2 to find the average of each row.  When I bring up the custom column window, it already says there's an error, just like in the image in the first post in this thread.  I enter the formula, it says there's no syntax errors, but it's still inside the red error box.  If I execute it anyways, all the cells in the created column say "error".  If I insert just one column of data into the formula, it duplicates the data into the created column, no problem, even though Power BI still said there was an error.  I tried using a different data set and had the exact same thing happen.  There's an error before I even start inserting anything into the formula.  The error message never goes away.  I uninstalled Power BI, and reinstalled it.  Still the issue persists.  Maybe it's a setting?  I'm stumped.

Any help would be greatly appreciated!

[DonutsFearMe]

I solved my issue!

I didn't realize that the version of Office 365 on my computer was the 32 bit version.  I had downloaded the 64 bit Power BI.  To fix the issue, first, I had to uninstall both Office 365 and Power BI.  Then download and install the 64 bit version of Office 365, then download and install the 64 bit Power BI.  No more odd errors!

Hopefully this helps anyone with a similar issue.

Have a great day!

[_eteamidc]

Any help is really appreciated - Thank you

[ronrsnfld]

The behavior you describe with no formula seems normal to me.  However, I cannot add a custom column with no formula. That creates an error message that the "formula is incomplete" in the dialog.

If you are adding a formula and seeing an error for the result in the cells, I suspect the error comes from your formula.

What is the formula and what is the error message?

[_eteamidc]

That is the puzzling part - I just clicked on adding a Custom Column 
no formula has been written yet

[JamesRobson]

Mine has always displayed that message when nothing added to the formula field (granted I dont have the red section), does it stop you adding the custom column?

[_eteamidc]

Yes, it does! I mean the new custom column is created but it contains "Error" as the value