Power QueryExercises

Culture (locale)

Regional conventions such as en-GB or de-DE that decide how text like 05/03/2026 or 1.234,5 is read when converting to dates and numbers.

The same text means different values in different cultures: 05/03/2026 is 5 March in en-GB and May 3 in en-US, and 1.234 is a thousand in de-DE but just over one in en-US. Passing the culture of the source file makes conversions give the same result on every machine.

In the Power Query editor

Change Type → Using Locale…, or the culture argument of Table.TransformColumnTypes in the formula bar.

Common mistake

Setting the column type with a plain Change Type step and trusting the preview. The preview uses the culture of the machine you are working on, so a file of UK dates can look right on your laptop and turn into errors or swapped days and months on a colleague's machine or in the Power BI service. Name the source's culture in the type step instead. If one column mixes formats, split it by format first, because a single culture can't read both.

Learn more

Practise it