PowerQuery M - How to refer to a column name that as an apostrophe?

Question

I have a column name such as Titre d'emploi, and when i refer to it as [Titre d'emploi], it gives me an error and i tried multiple things like ["Titre d'emploi"], and i googled for quite a while but nothing really applies.

Would you guys have any idea of how to refer to it?

Many thanks!

score 1 · Accepted Answer · answered Feb 22 '19 at 21:39

1

It should be similar to the automatically generated step names in the advanced editor:

[#"Titre d'emploi"]

You should be able to discover this yourself by looking at the code generated when you do something to that column. For example, if you choose Transform > Statistics > Count Values, then you'll get code like this:

= List.NonNullCount(#"Previous Step Name Here"[#"Titre d'emploi"])

answered Feb 22 '19 at 21:39

Alexis Olson

38,724
7
42
64

Ah yes! thanks for the tips, it works. I've been looking for hours ! – Swords_Plowshare Feb 22 '19 at 21:45
Or you can right click the column -> drill down, and it'll generate the same name – ninMonkey Jan 21 '21 at 20:10

PowerQuery M - How to refer to a column name that as an apostrophe?

1 Answers1