Power Query benutzerdefinierte Spalte

[Steffichoco]

Hallo,

ich hoffe mir kann einer weiterhelfen.

Ich verwende Excel 2016 und ich möchte gerne eine benutzerdefinierte Spalte einfügen.

wenn ich dies jedoch tue, werden mir keine Formelfunktionen angezeigt. Bei Oz du soleil werden jedoch die Funktionen mit den genauen Angaben angezeigt.

Viele Grüße,

Stefanie Weber 

[#2]

@Steffichoco 

Add a conditional column (Power Query)

https://support.microsoft.com/en-us/office/add-a-conditional-column-power-query-f2422ed1-f565-4e64-b...

Insert a custom column into a table (Power Query)

https://support.microsoft.com/en-us/office/insert-a-custom-column-into-a-table-power-query-2dbb579a-...

Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

Hope this information can help you.

Thank you for your patience and time.

Wish you a nice day / night with lots of health, joy and love.

Nikolino

I know I don't know anything (Socrates)

[#3]

@Steffichoco 

Stefanie, Oz generates at least one video per week, better to have link on concrete one. Perhaps you mean such list

Click Ctrl+Space or start typing the function, list will appear. 

And be sure intellisense is enabled for Power Query editor.

Can't check right now if all above works for 2016.

[#4]

@Sergei Baklan 

Hey 

I checked the options of power query and made it like you said, but it doesnt work as you see below..

What else I can do?

Kind regards,

Stefanie

[#5]

@Steffichoco 

Stefanie, not sure.

@Detlef Lewin , do you know if intellisense works on local version?

[#6]

@Sergei Baklan 

I can't tell for Excel 2016 but intellisense works in Office365 Current Channel German localisation.