M language

M is Power Query's functional language: each step is an expression that takes the result of the previous one. The editor generates it, and the advanced editor or the formula bar let you read and edit it.

Example

let
  Source = Csv.Document(File.Contents("ventes.csv")),
  Typage = Table.TransformColumnTypes(Source, {{"Montant", type number}})
in
  Typage

Related concepts

The whole glossary