Forum Discussion
Solved
Convert a [MONTH and [YEAR] column to a DATE.
Hi,
I have a csv document with a [MONTH] and [YEAR] column as shown. I would like to comine these two into a date column making it eg: 01/08/2022 for each entry.
Kindest regards.
=Table.AddColumn(PreviousStepName,each Date.From(Text.Format("#[year]-#[month]-1",_)))
Paste this portion in...
Date.From(Text.Format("#[year]-#[month]-1",_))If this solves your problem, please accept wdx223_Daniel's answer above as the solution. Not this one.
3 Replies
- wdx223_Daniel
Community Champion
=Table.AddColumn(PreviousStepName,each Date.From(Text.Format("#[year]-#[month]-1",_)))
Forgive my amatuer-ish-ness but how would you complete that without the advanced editor? In this interface?
- KNP
Super User
Paste this portion in...
Date.From(Text.Format("#[year]-#[month]-1",_))If this solves your problem, please accept wdx223_Daniel's answer above as the solution. Not this one.
