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
- intermediate~8 minFree
Convert day-first dates with the right locale (consultancy)
Claim dates are written 05/03/2026 meaning 5 March. Convert them to real dates using the en-GB culture.
- intermediate~7 minFree
Read amounts written with a decimal comma (consultancy)
A German export writes 1.234,56 for one thousand two hundred thirty-four point five six. Convert it with the de-DE culture.