Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Convert TEXT date into DATE - POWER QUERY

Hello,  I have a date in the format of text, please see below. How can I turn this into format date dd.mm.yyyy ?  IF I use change the format in the header, this step doesnt work and make an "error"...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hello, Anonymous 

    Table.TransformColumns(your_table, {"Zdroj...", (x) => Date.FromText(x, [Format = "ddMMyyyy"])})
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

Hello, Anonymous 

Table.TransformColumns(your_table, {"Zdroj...", (x) => Date.FromText(x, [Format = "ddMMyyyy"])})