Create a Date from Numbers in PowerBOI

[gavs73]

Hi, would appreciate any help with this, I have two columns YEAR and MONTH in my query, both as Numbers, what is the best way to combine them into a Date in the Power Query Editor ?, I am happy to have the 1st day of the month, so for example, Year 2020 Month 9, needs to become 09/01/2020 in DATE Format. Thanks for your help. Gav

 

[RoryA]

Just:

=#date([Year],[Month],1)

should do it.