Power QueryExercises

Data type

What a column's values mean: text, whole number, decimal, date, logical and so on. Types drive comparisons, sorting and what downstream tools see.

Types decide how values compare and sort: as text, "10" sorts before "9". A column typed any can hold mixed values and loads as text in many tools. Setting types explicitly right after import, and again after appends or expands, prevents most downstream surprises.

In the Power Query editor

The icon at the left of each column header shows its type (ABC for text, 123 for whole number, a calendar for date).

Learn more

Related functions

Practise it