ERROR Formula is Incomplete in Power Query

[krrishkrsna]

Hi,

in Power Query > clicked on menu Add Column > clicked Add Custom Column > typed formula as
=Date.AddDays([Date],4)

but facing the ERROR as "Formula is Incomplete"

unable to upload screenshot

please help asap

thanks and regards
Krishna

 

[theBardd]

It works fine for me. Is anything else going on, do you have any steps prior to this (other than sourcing it)?

 

[krrishkrsna]

i saw video of ExcelIsFun regarding PowerQuery and followed same steps but not worked through Add Custom Column.

used same formula in Advanced Editor, works fine for me.

so searched in google and youtube, did not get the SOLUTION

 

[MarcelBeug]

My suspicion is that you typed the formula in the box for the name of the field instead of in the box for the formula.

I receive the message "Formula is Incomplete" only if I didn't type anything yet in the fomula box (so there is only the prefilled "=").

 

[krrishkrsna]

hahahahahahaha

i watched all beautiful videos of ExcelIsFun regarding PowerQuery and succeeded in learning all those except to adding the formula through Custom Column as shown in video

i typed column name in column box and formula in formula box but still ERROR

 

[MarcelBeug]

Last try: watch this video.

 

[krrishkrsna]

thanks for Video. yous working fine but for me not .
recorded video link provided below for your reference
(no Sound)

https://youtu.be/hPuFw_DidRM

 

[MarcelBeug]

Also your video is not working. YouTube states: "This video is unavailable."...

 

[theBardd]

I got a message saying it was private.

 

[krrishkrsna]

hi

Sorry for setting it to Private in Youtube. i changed settings. plz check and give solution