Forum Discussion

Jiro's avatar
Jiro
Frequent Visitor
3 years ago
Solved

Seek advices: text to date

Hi everyone,   I was trying to transform texts into dates with the below formular in power query editor; however it did not seem to be working. I am totally new here, so would appreciate your kind ...
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    = Table.TransformColumns(Source, {"Column1", each Date.FromText(_&"01"), type date})
    where 'Source' is your previous step.

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

= Table.TransformColumns(Source, {"Column1", each Date.FromText(_&"01"), type date})
where 'Source' is your previous step.

  • Jiro's avatar
    Jiro
    Frequent Visitor
    3 years ago

    Thank you so much jgeddes!

     

    May I also seek your advice where should I start learning to be able to write the code myself?