Forum Discussion
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 advice. Thank you.
text:
201909
201910
201911
into:
09/01/2019
10/01/2019
11/01/2019
= Date.From(DateTime.FromText([YourColumn] & "01", "MMddyyyy"))
= Table.TransformColumns(Source, {"Column1", each Date.FromText(_&"01"), type date})
where 'Source' is your previous step.
3 Replies
jgeddesSuper User
= Table.TransformColumns(Source, {"Column1", each Date.FromText(_&"01"), type date})
where 'Source' is your previous step.Thank you so much jgeddes!
May I also seek your advice where should I start learning to be able to write the code myself?
- jgeddes
There are a lot of great resources to help you learn M code.
Here is a link with some...
https://www.thebiccountant.com/learning-resources/Good luck on your learning journey!
