Power QueryExercises

Table.TransformColumnTypes

Table function · By Tahir Nas · Examples run in our simulator · Published · Updated

Converts columns to types, optionally with a culture.

When to use it

Use it right after import (and after appends or expands) to give every column its real type. Pass the source culture when dates or decimals use a different format from your machine. Review the generated Changed Type step, which hard-codes every column name.

Syntax

Table.TransformColumnTypes(table as table, typeTransformations as list, optional culture as nullable text) as table

Parameters

typeTransformations
A list of {column, type} pairs.
culture
Culture used to read text, such as "en-GB".

Returns

The table with converted columns.

Example

Table.TransformColumnTypes(#table({"Day", "Amount"}, {{"05/03/2026", "1.234,5"}}), {{"Amount", type number}}, "de-DE")

Result

DayAmount
05/03/20261234.5

Example: day-first dates with a culture

en-GB reads 05/03/2026 as 5 March; en-US would read it as May 3.

Date.Month(Table.TransformColumnTypes(#table({"Day"}, {{"05/03/2026"}}), {{"Day", type date}}, "en-GB"){0}[Day])

Result

3

Both results are produced by the Power Query Exercises simulator, an independent implementation of a documented subset of M, and checked on every build.

Good to know

Common mistakes

The matching command in Excel

Excel for Windows
Home > Data Type, or right-click > Change Type > Using Locale
What you see
The type icon in the header changes, and Using Locale adds the culture to the step.

Paths are for the Power Query editor in Excel for Microsoft 365, checked against Microsoft's documentation on 8 November 2026: Data types in Power Query (Microsoft Learn).

Exercises that use Table.TransformColumnTypes

Learn more

Related functions

Official documentation: Table.TransformColumnTypes on Microsoft Learn.