Convert a [MONTH and [YEAR] column to a DATE.

[cwfmoore]

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.

[wdx223_Daniel · Accepted solution]

=Table.AddColumn(PreviousStepName,each Date.From(Text.Format("#[year]-#[month]-1",_)))

[wdx223_Daniel · Accepted solution]

=Table.AddColumn(PreviousStepName,each Date.From(Text.Format("#[year]-#[month]-1",_)))

[cwfmoore]

Forgive my amatuer-ish-ness but how would you complete that without the advanced editor?  In this interface?

[KNP · Accepted solution]

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.