Date from month column

[Anonymous]

Hi everyone,

I have a month column (January, February and so on) and a year column (2019, 2020 and 2021). I want to get a date column from they both. I recall once I saw a video where I could do something like  #date(2020,"January",1) and it returns 1/1/2020 as date. 

I do not remember the code but I hope you get what I am trying to achieve.

Thanks!!!

[mahoneypat · Accepted solution]

You need to use this syntax -  #date(2020,1,1)

Or you can add a column with this expression (assumes Year is number column).

= Date.From([Month] & Text.From([Year]))

Pat