Power QueryExercises

M language

Power Query's formula language. It's functional and case-sensitive: every query is an expression, typically a let … in block, that produces a value such as a table.

M is a functional language: values never change, and each step produces a new value from earlier ones. It has its own types (text, number, date, list, record, table, function) and its own standard library of several hundred functions such as Table.SelectRows. It's not the same as DAX, which calculates measures over a loaded model.

In the Power Query editor

The formula bar shows the M for the selected step, and Home → Advanced Editor shows the whole query.

Learn more

Practise it

Related terms