cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kunuthuri Member
Member

custom column

Hi

 

Working with different custom column formulas , OK button is not enabling in my system.

 

.custom column ok button disabled.PNG

 

Thanks

 

 

4 REPLIES 4
Super User
Super User

Re: custom column

Strange, similar issue was reported here.

 

What version are you using (File - Help - About)?

 

Mine is Version: 2.46.4732.461 64-bit (May 2017), but there is a newer version already.

Specializing in Power Query Formula Language (M)
Super User
Super User

Re: custom column

Ah, the same reporter... why didn't you continue with your previous topic, as it is the same issue?

Or maybe you tried to, byt raised a new topic by mistake.

 

Specializing in Power Query Formula Language (M)
v-huizhn-msft Super Contributor
Super Contributor

Re: custom column

Hi @kunuthuri,

Please try "=[Content]" to create a custom column, and check if it works fine.

 

Excel.Workbook() function, returns a table representing sheets in the given excel workbook. I am not clear your purpose of using it. It returns a error message: The formula is incomplete. Only there is no syntax errors, the "OK" is enabling.

1.PNG


Could you please share more details for further analysis?

Best Regards,
Angelia

v-huizhn-msft Super Contributor
Super Contributor

Re: custom column

Hi @kunuthuri,

Have you resolved your issue? If you have, please mark right reply as answer. Thanks for understanding.

Best Regards,
Angelia